Database Engine Error: Invalid BLOB handle in record buffer.

[Dario Basso Cardoso]

Hi,

In simple operation

return ltrim(rtrim(cString))

When i while not eof in query SQL of PostgreSQL i receive this message


Database Engine Error: Invalid BLOB handle in record buffer.


How i resolv this?

Thanks,


Dario

[Lysander]

Post by Dario Basso Cardoso
Database Engine Error: Invalid BLOB handle in record buffer.
How i resolv this?

It would be good to see more code.
Most likely you are going _BACK_ from your actual pointer more records
than your buffer is holding. It might seem trivial, but moving BACKwards
in a table is nothing that any SQL server can easily do. All of them are
using some "magic" to do so :)

There is a quick solution and a good one.

The quick solution is to increase the value "BLOBs to cache" in your
BDE-Alias. You must increase it so much that the highest possible number
of records can be accessed BACKWARDS from your actual rownumber.

The good solution is to avoid jumping backwards when reading data into
one stream. While increasing the BLOBs to cache will work in theory, you
will have to increase it very very much to work also in practice. And
that of course can consume some amount of RAM and makes synchronizing
data between local BDE and Server slooooooowwwwwww.