一、数据库为Sqlserver2000
二、数据表a的结构如下
create table a (
c1 char(6) not null,
c2 text not null
)
三、Delphi程序中在读取a表的内容
var
q1 : tquery;
begin
...
q1.close;
q1.sql.clear;
q1.sql.add('select * from a');
q1.prepare;
q1.open
...
end;
四、程序界面设一tmemo控件对应上述'c2'字段
...
c2.text := q1.fieldvalue('c2');
...
五、q1记录指针的移动，tmemo的text文本也应变动
六、问题：
1、初始运行没有问题，时间一长就会报错：bdeengineer error:invalid blob handle in record buffer.
2.但如果把C2的属性改为char(255)就没有问题了。
请哪位高手帮我解决一下，万分感谢！

你好像用的是BDE连接数据库的吧
将BDE中的Blob Size和Blob Cache调大

主要是BDE缓存不够用。

BLOB SIZE

Determines the fetch buffer size for dead BLOBs. Applications that deal with dead BLOBs using dead table opens or queries or batchmoves can set a maximum limit on the size of BLOBs to fetch. Setting this parameter to 64 means your application can fetch BLOBs of up to 64K.
This parameter does not apply to live table opens.
Default Value: 32
Range : >32 and <1000

BLOBS TO CACHE

Determines how many BLOBs will be cached on the client. Applications that deal with fetching dead BLOBs using dead table opens or queries can set a limit on the number of BLOBs to cache depending on the resource available on the client.
Setting a value 100 means the application can work with a maximum of 100 BLOB records cached. Fetching more than 100, then scrolling back 100 records results in an "Invalid Blob handle in record buffer" error message.
This parameter does not apply to live table opens.
Default Value: 64
Range : >64 and < 65536

该注意的地方，我给你标志出来了！不理解BLOB Size和Blob To Cache可以参考我给你的资料！