Reading a BLOB in Query Live mode

From: Kanv <kanvpandit_at_hotmail.com>
Date: 14 May 2003 00:36:43 -0700
Message-ID: <2554c5c7.0305132336.3c17ce5b@posting.google.com>

Hi,

Our application reads a BLOB field in 'Request Live Query' mode, during transaction processing. At this time, certain updates to other VARCHAR fields are also made for the selected record.

Problem: When the BLOB field is read in 'Request Live Query' mode, the data fetched/provided through the BLOB is missing the last byte. Meaning, the BLOB contains an end char, a delimiter, which when fetched in the above process, is not visible/available at all to the application. End result, transaction processed is missing one byte. Why is this happening? Any ways to avoid?

For information's sake, DB conn is made through Borland BDE 5.2

Thx,
KaNv Received on Wed May 14 2003 - 02:36:43 CDT