procedure TForm1.btn1Click(Sender: TObject);
var str:Tmemorystream;
begin
btn1.Enabled:=false;
str:=Tmemorystream.Create;
str.LoadFromFile('000.bmp');
try
myqry1.SQL.Clear;
myqry1.SQL.Text:='select * from whmember';
myqry1.Open; myqry1.Edit;
Tblobfield(myqry1.Fields.Fields[myqry1.FieldList.Count-1]).loadfromstream(str);
myqry1.Post; showmessage('ok');
finally
str.Free;
btn1.Enabled:=true;
end;
end;
{
---------------------------
Debugger Exception Notification
---------------------------
Project Project1.exe raised exception class EMySqlException with message '
#42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'J揾嫿w崷剽觳oO禧耢?毡熴聘禧耢禧耢瞣OGCHJFLOLUONW9?D:FHJ\\[QfcUkiG[' at line 3'. Process stopped. Use Step or Run to continue.
---------------------------
OK Help
---------------------------
}
var str:Tmemorystream;
begin
btn1.Enabled:=false;
str:=Tmemorystream.Create;
str.LoadFromFile('000.bmp');
try
myqry1.SQL.Clear;
myqry1.SQL.Text:='select * from whmember';
myqry1.Open; myqry1.Edit;
Tblobfield(myqry1.Fields.Fields[myqry1.FieldList.Count-1]).loadfromstream(str);
myqry1.Post; showmessage('ok');
finally
str.Free;
btn1.Enabled:=true;
end;
end;
{
---------------------------
Debugger Exception Notification
---------------------------
Project Project1.exe raised exception class EMySqlException with message '
#42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'J揾嫿w崷剽觳oO禧耢?毡熴聘禧耢禧耢瞣OGCHJFLOLUONW9?D:FHJ\\[QfcUkiG[' at line 3'. Process stopped. Use Step or Run to continue.
---------------------------
OK Help
---------------------------
}
解决方案 »
- 我的my.cnf, 都调到最低了,还是占用了300多M虚拟内存
- mysqk怎样实现gbk_bin编码又不区分大小写?
- 同一个字段的2次排序问题~
- mysql 还需要优化??
- 关于MySQL中的/*!…… */意义
- mariadb 5.2.3 启动出错
- insert语句中利用select子查询插入数据 出错
- 大家帮我看看这个mysql索引创建的问题
- Invalid authorization specification: Access denied for user: '[email protected]' (Using password: YES)
- Error in `/usr/local/mysql/bin/mysqld': malloc(): memory corruption: 0x00007f26b
- 配置问题
- 关于MySQL中char(4)汉字输入的问题
mysql的语句必须以;结束myqry1.SQL.Text:='select * from whmember;';改成这样试试