"?Invalid BLOb handle" error: What is the cause and how do I fix this error

Question:

"Invalid BLOb handle" error: What is the cause and how do I fix this error?

Answer:

If the error occurs on a non-live (dead, canned) query or a table with no indexes, then increasing the new BDE 4.x configuration parameter 'BLOBS TO CACHE' will fix the problem. This setting determines how many BLObs will be cached on the client. Applications that deal with fetching dead BLObs using dead table opens or queries can set a limit on the number of BLObs to cache depending on the resource available on the client. Setting a value 100 means the application can work with a maximum of 100 BLOb records cached. Fetching more than 100, then scrolling back 100 records results in an "Invalid BLOb handle in record buffer" error message.

NOTE:This parameter does not apply to live table opens.

Default Value: 64

Range: 64 to 65536

================

Invalid BLOB handle in record buffer


The problem got solved by setting the BLOBS TO CACHE to -1, not in the BDE but within the program.

 

 

در صورت برخورد با این خطا در پارامتر های مربوط به دیتا بیس مقدار  BLOBS TO CACHE را برابر -1 قرار دهید.

/ 2 نظر / 6 بازدید
مرد آبادانی

ای آبادان پر بلا! گلهای پرپرت کو؟ یاران رهبرت کو؟ http://abadanman.persianblog.ir/ http://abadanman.webphoto.ir/ http://abadanman.blogspot.com/

مرد آبادانی

ای آبادان پر بلا! گلهای پرپرت کو؟ یاران رهبرت کو؟ http://abadanman.persianblog.ir/ http://abadanman.webphoto.ir/ http://abadanman.blogspot.com/