如何同时删除两个表中的数据??我利用鼠标选择listview里的一行,然后删除。我的代码如下:
Query3.SQL.Clear;
Query5.SQL.Clear;
Query3.SQL.Add('delete from car where car_num='''+ListView2.Items[i].Caption+'''');
Query5.SQL.Add('delete from carpostion where car_num='''+ListView2.Items[i].Caption+'''');
ListView2.Items.Delete(i);
Query3.ExecSQL;
Query5.ExecSQL;
可我一执行就说冲突,我的另外一个表carpostion在另外一个form里面显示,在当前这个form中不显示。请问如何解决?错误在哪儿?
Query3.SQL.Clear;
Query5.SQL.Clear;
Query3.SQL.Add('delete from car where car_num='''+ListView2.Items[i].Caption+'''');
Query5.SQL.Add('delete from carpostion where car_num='''+ListView2.Items[i].Caption+'''');
ListView2.Items.Delete(i);
Query3.ExecSQL;
Query5.ExecSQL;
可我一执行就说冲突,我的另外一个表carpostion在另外一个form里面显示,在当前这个form中不显示。请问如何解决?错误在哪儿?
Query3.SQL.Add('delete from car where car_num='''+ListView2.Items[i].Caption+'''');
Query3.ExecSQL;
Query5.SQL.Clear;
Query5.SQL.Add('delete from carpostion where car_num='''+ListView2.Items[i].Caption+'''');
Query5.ExecSQL;
ListView2.Items.Delete(i);
指教一下,最好详细点,我不会
Query5.SQL.Close;
Query3.SQL.Clear;
Query5.SQL.Clear;
Query3.SQL.Add('delete from car where car_num='''+ListView2.Items[i].Caption+'''');
Query5.SQL.Add('delete from carpostion where car_num='''+ListView2.Items[i].Caption+'''');
ListView2.Items.Delete(i);
Query3.ExecSQL;
Query5.ExecSQL;