delphi delete后数据没有被删除
来源:百度知道 编辑:UC知道 时间:2024/06/20 12:50:52
with Query1 do
begin
Query1.Close;
Query1.SQL.Clear;
Query1.SQL.Add('Delete from customer.db where CustNo = ''1231''');
Query1.ExecSQL;
Query1.Open;
我用这段程序提交后,报了这个错误“master has detail records,cannot delete or modify.“
请问怎么修改,,
to c_engineer :
按照你说的我改了下,现在报了这个错误:
'Invalid use of keyword,
Token:*
Line Number:1.
begin
Query1.Close;
Query1.SQL.Clear;
Query1.SQL.Add('Delete from customer.db where CustNo = ''1231''');
Query1.ExecSQL;
Query1.Open;
我用这段程序提交后,报了这个错误“master has detail records,cannot delete or modify.“
请问怎么修改,,
to c_engineer :
按照你说的我改了下,现在报了这个错误:
'Invalid use of keyword,
Token:*
Line Number:1.
1、语句错误:
Delete from...应为 Delete * from...
2、Query.ExecSQL以后就不要Query1.Open了。
你的语句有问题吧
是delete * from.....
牵涉到主从表,楼主你删除主表里的数据时,一定要把从表里相关记录先删除