×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

invalid blob handle in record buffer error

invalid blob handle in record buffer error

invalid blob handle in record buffer error

(OP)
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,

RE: invalid blob handle in record buffer error

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

RE: invalid blob handle in record buffer error

(OP)
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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close