Invalid BLOB handle in record buffer - error
Posted on 2004-03-21
I have a problem with my code. I need to extract the text from the blob field of an Access database table.
I use a stringgrid (kStringGrid) where I want to push all the records of the table initial Access table. This table has a BLOB field which I cannot view unles I use a DBMemo. What I'm trying to do is take each record from the first to the last and save the fields I'm interested in to the stringgrid. I built a procedure to do that.
So my code looks like this:
with form1 do
If u<>p then
p:=DBGrid1.Fields.AsString; //field 1 (string)
s:=Memo3.Lines.Strings; // FIELD 2 (comment) THE BLOB I NEED
Can anyone tell me what may be wrong about this. I read a few lines about this error but I could not solve my problem though. They wer about BLOB CACHE size... .
I'm sure I'm not the first that encounters this problem nor this error.
Any good code is welcome.