Главная страница | назад

Article #19666: SQL Anywhere and Blobs>32K when RequestLive=False

 Question and Answer Database

     FAQ: FAQ4666B - SQL Anywhere and Blobs>32K when RequestLive=False
Category: Database (ODBC)
Platform: All-32Bit
 Product: BC++5.x,   C++Builder1.0,   C++Builder3.x,   C++Builder4.x,   Delphi2.x,   Delphi3.x,   Delphi4.x,   VdBase7.x,   


If I RequestLive=False with a TQuery, can I get blob data from SQL Anywhere greater than 32K?


Not at this time. SQL Anywhere is not a certified driver and operates differently than any driver Inprise has certified. 

With other drivers, if Blob Size is set large enough, Data is Fetched successfully. With SQL Anywhere, even if Blob Size is large 
enough, the driver returns an error and fetching the data is unsuccessfull. 

TQueries with RequestLive=True appear to work because the exact size of the buffer is
requested. Whereas when requestlive=false, your blobsize setting is used. If buffersize
is too large, SQL Anywhere returns an error, whereas other ODBC Datasources do not.

7/13/99 10:36:38 AM

Last Modified: 01-SEP-99