Solved

Why after updating the record which has a "Text" field, it shows: "Invalid BLOB handle in record Buffer."

Posted on 2004-09-01
3
222 Views
Last Modified: 2010-04-05
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:='select * from company'
           Two components in the form, one is Edit, The other is Memo for the text field.
               CompanyNameEdit.Text:=CompanyQuery.FieldByName('CompanyName').asstring;
               NotesMemo1.Text:=CompanyQuery.FieldByName('Notes').AsString;

Update:      s:='Update Company set '
                  + 'CompanyName="'+CompanyNameEdit.Text+'",'
                  + 'Notes="'+NotesMemo1.Text+'" '
                  + 'Where CompanyID='+CompanyQuery.FieldByName('CompanyID').AsString;
0
Comment
Question by:adamy
  • 2
3 Comments
 
LVL 13

Expert Comment

by:BlackTigerX
Comment Utility
are you using BDE?
if you are:
- what version are you using?
- have you tried changing the BLOBS TO CACHE in the BDE administrator?
0
 
LVL 1

Author Comment

by:adamy
Comment Utility
Yes, I am using BDE v5.01. What should I change 'BLOBS TO CACHE' to?
0
 
LVL 13

Accepted Solution

by:
BlackTigerX earned 50 total points
Comment Utility
just a bigger number of what you have right now... how many records to you request in a query?
you want to put as many records as you would retrieve in a query
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Suggested Solutions

The uses clause is one of those things that just tends to grow and grow. Most of the time this is in the main form, as it's from this form that all others are called. If you have a big application (including many forms), the uses clause in the in…
Objective: - This article will help user in how to convert their numeric value become words. How to use 1. You can copy this code in your Unit as function 2. than you can perform your function by type this code The Code   (CODE) The Im…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now