试试:with Query1 do
begin
Close;
sql.Clear;
sql.Add('UPDATE FORMS SET FORMNO= '''+StrToInt(某个变量)+''' WHERE SETNO=''' + StrToInt(变量) + '''');
Execsql;
end;
begin
Close;
sql.Clear;
sql.Add('UPDATE FORMS SET FORMNO= '''+StrToInt(某个变量)+''' WHERE SETNO=''' + StrToInt(变量) + '''');
Execsql;
end;
begin
Close;
sql.Clear;
sql.Add('UPDATE FORMS SET FORMNO= '+IntToStr(某个变量)+' WHERE SETNO=' + IntToStr(变量) );
Execsql;
end;
谢谢wangzh,谢谢各位!