With Query1 do begin Close; databasename:'数据库别名'; Sql.add(delete from 表名); ExecSql; end
databasename:'数据库别名'; 改成 databasename:='数据库别名';
With Query1 do begin Close; databasename:='数据库别名'; Sql.add('Select * from 表名'); open; end; IF Query1.Fields[0].AsString<>'' then begin With Query1 do begin Close; Sql.Clear; databasename:='数据库别名'; Sql.add(delete from 表名); ExecSql; end; end else showmessage('没有数据');
begin
Close;
databasename:'数据库别名';
Sql.add(delete from 表名);
ExecSql;
end
改成
databasename:='数据库别名';
begin
Close;
databasename:='数据库别名';
Sql.add('Select * from 表名');
open;
end;
IF Query1.Fields[0].AsString<>'' then
begin
With Query1 do
begin
Close;
Sql.Clear;
databasename:='数据库别名';
Sql.add(delete from 表名);
ExecSql;
end;
end
else
showmessage('没有数据');
Dbgrid1.Datasource.DataSet.Refresh;
这一句添加在ExecSql后面
With Query1 do
begin
Close;
Sql.Clear;
databasename:='数据库别名';
Sql.add('delete from 表名');
ExecSql;
end;