invalid blob handle in record buffer error

[mwitwer]

Numerous times I have received an error stated as "Invalid BLOB handle in record buffer" when attempting to update tables. I am not even using BLOBs in this project at all. The error is very inconsistent, or at least I have difficulty duplicating it.

I am using transactions through the BDE TDatabase component and caching updates on all TDataSet components owned by the DB component (using TDatabase.ApplyUpdates to actually update the cached tables). It is a single-user, local db project, but there are numerous tables that are related to one another that must stay in sync to keep the data correct and this why I am using cached updates with transactions.

Can anybody tell me what may cause this error, especially when no BLOBs are involved? Many times an 'At end of table' error comes soon after the initial error, but not always.

Any light shed on this error will be much appreciated.

Thanks,

 

[TealWren]

What Database back end are you using?

Any text, varchar, etc. fields > 255 characters is considered a blob. Common fix for this issue is increasing the "BLOBS TO CACHE" option in the BDE. If you don't have any blobs or any fields > 255 characters this may not be the issues though.

TealWren

 

[mwitwer]

I don't have any fields that contain more than 255 characters. But I think I may have found a solution. The tables that I was using were of mixed Paradox levels; some level 4, some 5, some 7. Since it is a single-user local database application meant only to run on 32-bit windows, I made sure that I made all of my tables Level 7. The BDE Admin help says that Level 7 does not support BLObs (which is just fine with me and may finally get rid of the messages). In the BDE Admin there is no setting such as BLOBS TO CACHE in a Paradox Level 7 table.