同意crasher(冬冬) 实在不行,试验 delete from tt where LTrim(RTrim(编号))='0001'
试试这个 Query1.Sql.Add('delete from tt where 编号='''+'0001'''); 或者先Locate再Delete
delete from tt where 编号="0001"
可能是中文的问题,先试一试 sql.clear; sql.add(delete from tt where 编号="0001"'); execsql;不行再换成: sql.clear; sql.add(delete from tt where id="0001"'); execsql;应该可以
更正:可能是中文的问题,先试一试 sql.clear; sql.add('delete from tt where 编号="0001"'); execsql;不行再换成: sql.clear; sql.add('delete from tt where id="0001"'); execsql;应该可以
实在不行,试验
delete from tt where LTrim(RTrim(编号))='0001'
Query1.Sql.Add('delete from tt where 编号='''+'0001''');
或者先Locate再Delete
sql.clear;
sql.add(delete from tt where 编号="0001"');
execsql;不行再换成:
sql.clear;
sql.add(delete from tt where id="0001"');
execsql;应该可以
sql.clear;
sql.add('delete from tt where 编号="0001"');
execsql;不行再换成:
sql.clear;
sql.add('delete from tt where id="0001"');
execsql;应该可以