TDataSetProvider.Options := [poFetchBlobsOnDemand]
Posted: 14.09.2011, 18:40
Hi! I'm using MSSQServer+Zeos+TDataSetProvider+TClientDataSet to obtain data in Master-Detail mode.
All works fine but I would like load all related rows except blobs fields and use any function for retrieve it in ClientDataSet opened.
When I set poFetchBlobsOnDemand = true the effect is the same. I think that ClientDataSet is retrieving all blobs files because the SQL execute is slow too. If I run a trace on the server, I see that blob fields are included in "Select".
How could I do it? Is the combination Zeos/MSSQServer does not work?
What i'm doing wrong? Maybe I just is missing some detail. I would greatly appreciate to give me a clue
regards
Tavo
All works fine but I would like load all related rows except blobs fields and use any function for retrieve it in ClientDataSet opened.
When I set poFetchBlobsOnDemand = true the effect is the same. I think that ClientDataSet is retrieving all blobs files because the SQL execute is slow too. If I run a trace on the server, I see that blob fields are included in "Select".
How could I do it? Is the combination Zeos/MSSQServer does not work?
What i'm doing wrong? Maybe I just is missing some detail. I would greatly appreciate to give me a clue
regards
Tavo