Invalid BLOB handle in record buffer
Posted on 2003-02-24
I am using a TTable component in Delphi 7 to access a table that has BLOB fields. As I navigate around the table I get an invalid BLOB error. I understand why I get the error, the fact being that it caches the BLOB fields and when I go back too many records, the BLOB handle is invalid. I don't want to just increase the number of BLOBs that are cached.
My question is, how can I code my program so that as I move around it doesn't try and use a cached BLOB, but always loads a new BLOB? I was thinking that maybe I could use an event handler somehow to do this.