不论是update还是delete from都出错,连接的paradox数据库源代码如下 Form1.Database1.Connected:=False;
Form1.Database1.DatabaseName:='MyDB';
Form1.Database1.Params.Clear();
Form1.Database1.Params.Add('path=e:\test\');
Form1.Database1.DriverName:='STANDARD';
Form1.Database1.Connected:=True;
Form1.Database1.Execute('delete from T01_ACAI where ChannelNum=2',nil,False,nil);其中T01_ACAI是表名,ChannelNum是字段名
Form1.Database1.DatabaseName:='MyDB';
Form1.Database1.Params.Clear();
Form1.Database1.Params.Add('path=e:\test\');
Form1.Database1.DriverName:='STANDARD';
Form1.Database1.Connected:=True;
Form1.Database1.Execute('delete from T01_ACAI where ChannelNum=2',nil,False,nil);其中T01_ACAI是表名,ChannelNum是字段名
有些是: DELETE FROM TabName WHERE ...
有些都支持。
不知道采用的哪个数据库?