From: Alexander P. <ale...@re...> - 2009-02-18 19:01:43
|
Martijn Tonies wrote: > Hello Alexander, > > > I've tried a different componentset and it browses data just > fine in Delphi. > > However, I ran into a new problem -- > > I have this table with BLOBs, I put down an odbc query > component in Delphi and set "UniDirectional" to True. > > When I want to activate the query component, it calls > SQLExecute and then doesn't return for quite a while. > Meanwhile, the memory usage of the application goes > -way up- ... and it ends with an Access Violation error. > > Is the driver fetching all rows despite the component > not doing that? > > > Hello Martijn! What components do you use? I think you need the Cursor type = ForwardOnly (else the driver fetching all rows) . Regards, Alexander |