with query1 do begin if active then close; sql.clear; sql.add(); open; end;
還有一點,你查看一下雙擊query1控件有沒有把記錄列在里面,如果有,要刪除它們.
在FORMSHOW事件中写入 IF NOT QUERY1.ACTIVE THEN QUERY1.OPEN; 以后若要调要QUERY,那就动态添加SQL语句吧 IF QUERY1.ACTIVE THEN QUERY1.CLOSE; QUERY1.SQL.CLEAR; QUERY1.SQL.ADD(‘’); QUERY1.OPEN;
with query1 do begin close; sql.clear; sql.add('select * from table'); open; end;
没有必要再设置active 属性了。 var sqlstr:string; being sqlstr:='select * from aaaa'//aaaa随便取的名字 with query1 do begin close; sql.clear; sql.add(sqlstr); try open; except showmessage('不能执指令'); end; end; end;
procedure TfmMain.FormCreate(Sender: TObject);begin query1.close; query1.clear; query1.sql.add('select * from table'); query1.open; end;procedure TfmMain.FormClose(Sender: TObject); begin fmMain:=nil;end;
begin
if active then close;
sql.clear;
sql.add();
open;
end;
IF NOT QUERY1.ACTIVE THEN QUERY1.OPEN;
以后若要调要QUERY,那就动态添加SQL语句吧
IF QUERY1.ACTIVE THEN QUERY1.CLOSE;
QUERY1.SQL.CLEAR;
QUERY1.SQL.ADD(‘’);
QUERY1.OPEN;
begin
close;
sql.clear;
sql.add('select * from table');
open;
end;
var
sqlstr:string;
being
sqlstr:='select * from aaaa'//aaaa随便取的名字
with query1 do
begin
close;
sql.clear;
sql.add(sqlstr);
try
open;
except
showmessage('不能执指令');
end;
end;
end;
query1.clear;
query1.sql.add('select * from table');
query1.open;
end;procedure TfmMain.FormClose(Sender: TObject);
begin
fmMain:=nil;end;