如何使用Delphi以编程方式从字段中删除数据

当我使用Delete删除数据时,它们仍然保留在dbf表中,但被标记为已删除

Procedure TForm1.Button2Click(Sender: TObject);

var god,data,max,date:string;

begin
date:=formatdatetime('dd.mm.yyyy',(DateTimePicker1.Date));
god:=copy(formatdatetime('yyyy',(DateTimePicker1.Date)),1,4);
data:=formatdatetime('ddmm',(DateTimePicker1.Date));
  ADOQuery1.Close;
  ADOQuery1.SQL.Clear;
  ADOQuery1.SQL.Append('Select max(date_pogr) as max from g_rabn.dbf where god='+''''+'''');
  ADOQuery1.Open;
  max:=ADOQuery1.FieldByName('max').asstring;
  if date<>max then
  begin
  ADOQuery1.SQL.Text:='delete from g_rabn.dbf where year='+''''+'''';
  ADOQuery1.ExecSQL;
  ADOQuery1.SQL.Text:='use g_rabn.dbf pack';
  ADOQuery1.ExecSQL;
  showmessage('Wrong date');
  end
  else
  begin
  ADOQuery1.SQL.text:='update g_rabn.dbf set year='+''''+year+'''' +' where year='+''''+'''';
  ADOQuery1.ExecSQL;
  ADOQuery1.SQL.text:='update g_rabn.dbf set data='+''''+data+'''' +' where data='+''''+'''';
  ADOQuery1.ExecSQL;

end;

end;
end.

如何从表中物理删除数据

cxl13461615166 回答:如何使用Delphi以编程方式从字段中删除数据

暂时没有好的解决方案,如果你有好的解决方案,请发邮件至:iooj@foxmail.com
本文链接:https://www.f2er.com/3167389.html

大家都在问