Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

"Invalid Blob handle in record buffer"-error PLEASE HELP

179 views
Skip to first unread message

Chris Viljoen

unread,
Dec 12, 2000, 6:07:36 PM12/12/00
to
Hi All

Can anyone please help me. I have a Query Object (Delphi4 C/S) which select
a SQL-Server7 Table with 2 text (Blob) fields. RequestLive is set to true.
When I post a new record with data in the 2 blob fields I get the error
"Invalid Blob handle in record buffer". I've set Blobs to Cache in BDE to
65535(Max)

What can I do to avoid this error

regards
Chris Viljoen
Skysoft


Kevin Davidson

unread,
Dec 12, 2000, 5:24:38 PM12/12/00
to
I don't know that this is still true, but at some versions of Delphi
I recall that you had to use Cached Updates with BLOBS instead of
Request Live.

Anton Santa

unread,
Dec 13, 2000, 2:05:20 AM12/13/00
to
Hi,

you have to set the BLOB SIZE parameter to a high value (ex. 1000), the
BLOBS TO CACHE meens the number of cached records (for the blob part).
Sometimes the problem could also be resolved in posting the changes to text
(blob) fields with a separate post. So do first do INSERT of the record with
non blob-fields, then put it in edit-mode, assign the blob-data and redo the
post.

hope this helps

Anton Santa


Chris Viljoen <CV...@skysoft.co.za> wrote in message 3a3623ae_1@dnews...

0 new messages