adamy
asked on
Why after updating the record which has a "Text" field, it shows: "Invalid BLOB handle in record Buffer."
I am using mySQL server as database. I display the company info which has a text field(BLob) in a form. First it's ok, but when I update or insert a record in the table and display it again. It shows:"Invalid BLOB handle in record Buffer.". Can you help me? How to solve this?
My Table: CREATE TABLE Company (
CompanyID INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
CompanyName VARCHAR(80) NULL,
Notes TEXT NULL,
PRIMARY KEY(CompanyID)
);
Display: CompanyQuery.SQL.text:='se lect * from company'
Two components in the form, one is Edit, The other is Memo for the text field.
CompanyNameEdit.Text:=Comp anyQuery.F ieldByName ('CompanyN ame').asst ring;
NotesMemo1.Text:=CompanyQu ery.FieldB yName('Not es').AsStr ing;
Update: s:='Update Company set '
+ 'CompanyName="'+CompanyNam eEdit.Text +'",'
+ 'Notes="'+NotesMemo1.Text+ '" '
+ 'Where CompanyID='+CompanyQuery.F ieldByName ('CompanyI D').AsStri ng;
My Table: CREATE TABLE Company (
CompanyID INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
CompanyName VARCHAR(80) NULL,
Notes TEXT NULL,
PRIMARY KEY(CompanyID)
);
Display: CompanyQuery.SQL.text:='se
Two components in the form, one is Edit, The other is Memo for the text field.
CompanyNameEdit.Text:=Comp
NotesMemo1.Text:=CompanyQu
Update: s:='Update Company set '
+ 'CompanyName="'+CompanyNam
+ 'Notes="'+NotesMemo1.Text+
+ 'Where CompanyID='+CompanyQuery.F
ASKER
Yes, I am using BDE v5.01. What should I change 'BLOBS TO CACHE' to?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
if you are:
- what version are you using?
- have you tried changing the BLOBS TO CACHE in the BDE administrator?