W
wp231957
Unregistered / Unconfirmed
GUEST, unregistred user!
我用如下办法对数据库中日期字段为NULL的进行了删除操作,请问,我能用SQL语句中的DELETE FROM TABLE WHERE 日期字段=空 的方式来实现吗 ( 积分: 10 )<br />query1.Close;
query1.RequestLive:=true;
query1.DatabaseName:='';
query1.SQL.Clear ;
query1.SQL.Text :='select * from "base.DBF"' ;
query1.open ;
while not query1.Eof do begin
if query1.Fields[1].IsNull then query1.Delete else query1.Next;
end;
query1.Close;
query1.RequestLive:=true;
query1.DatabaseName:='';
query1.SQL.Clear ;
query1.SQL.Text :='select * from "base.DBF"' ;
query1.open ;
while not query1.Eof do begin
if query1.Fields[1].IsNull then query1.Delete else query1.Next;
end;
query1.Close;