5,392
社区成员
发帖
与我相关
我的任务
分享
sql := 'UPDATE tab SET BGZW=:file' +
' where XTAJBH=''' + case_id + '''';
execInt := DataModule_sys.ExecLobUpdate(sql, 'file', self.Edit_text.Text);
//self.Edit_text.Text word 文档的路径和名称
// BGZW 数据库大字段
function TDataModule_sys.ExecLobUpdate(sql: string; LobName: string; FileName:
string): Integer;
begin
try
if self.ADOQuery1.Active then
self.ADOQuery1.Close;
self.ADOQuery1.Prepared := true;
self.ADOQuery1.ParamCheck := true;
self.ADOQuery1.SQL.Text := sql;
ADOQuery1.Parameters.ParamByName(LobName).LoadFromFile(FileName, ftBlob);
ADOQuery1.ExecSQL;
result := self.ADOQuery1.ExecSQL;
finally
self.ADOQuery1.Prepared := false;
self.ADOQuery1.ParamCheck := false;
self.ADOQuery1.Close;
end;
// (ADOQuery1.FieldByName('aaa') as TGraphicField)
end;