看看代码，怎样修改？？？在线！！！

[hyla1981]

query2.SQL.clear;
query2.SQL.Add('select factorykeyid from smpp_factory_key where factorykeyid=:keyid');
query2.Params[0].AsString := m_keyuniid;
query2.open;

if (query2.IsEmpty = True) then
begin
query2.sql.Clear;
query2.sql.add('insert into smpp_factory_key (factorykeyid,factorykey,regdate) ');
query2.sql.add('values (:fkeyid,:123,:ddate)');
query2.Params[0].AsString := m_keyuniid;
query2.Params[1].AsBlob := b_publickey;
query2.Params[2].AsDateTime := StrTodate('2002-12-18');
query2.ExecSQL;
end;

执行完后，怎样更新dbgrid里的数据。就是把数据在dbgrid及时显示出来

[hyla1981]

你们说的都不行啊

[dyf2001]

dbgrid.DataSource.DataSet.Refresh;

[chutian]

query2.IsEmpty = True //直接寫query2.IsEmpty 即可
我個人認為 (query2.Eof or query2.bof) 比較好.



Query2.Refresh;
or query2.close; query2.open;

[li_zhifu]

query2.sql.add('values (:fkeyid,:123,//这儿不行吧
:ddate)');
在后面再加上Select *....
和Open语句

[票票飞扬]

dbgrid.DataSource.DataSet.Active := True;

[li_zhifu]

Query2.Active:=False;
Query2.SQL.Clear;
Query2.SQL.Add('Select * From smpp_factory_key');
Query2.Active:=True;

[xuejinlong]

后面执行这段代码不就行了？
query2.SQL.clear;
query2.SQL.Add('select factorykeyid from smpp_factory_key where factorykeyid=:keyid');
query2.Params[0].AsString := m_keyuniid;
query2.open;