Delphi32.com - Home!
| Home/News | Downloads | Forums | D32 Magazine | Resources | Info and Facts |  
 
 SQL Anywhere and Blobs>32K when RequestLive=False


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/ 3/99 0:36:38 AM

     



  << Previous Faq     Complete List     Next Faq >>  



 
 Hits/month  2,500,000+ 
 Downloads
 (Since May 2000)
 7,393,709 
 Total Files  6,023 
 Forum msgs  7,670 
 Articles/FAQs  70+/900+ 
Kylix
Tips n Tricks
FAQs
Knowledge Base
Bug Listings
Articles
Books
Newsgroups
Links
Submissions
Testimonials
Advertising
Contact Us
About Us
Search Amazon:
Top Selling Software at Amazon

| Home/News | Downloads | Forums | Resources | Info and Facts | Testimonials |
  Site Search:
 


Comments/Problems: Webmaster@delphi32.com
Copyright © 1998-2006, Delphi32.com. All rights reserved.
Terms of Use