问题在于
try
query1.open;
except
query1.execsql;
end;
应改成
try
query1.execsql;
except
showmessage('数据库提交失败');
end;
try
query1.open;
except
query1.execsql;
end;
应改成
try
query1.execsql;
except
showmessage('数据库提交失败');
end;
应该将代码改为:
try
query1.execsql;
except
//error message...
end;
如果str1,str2中含有“'”,“ ,” 等符号也容易发生错误