使用adoquery+datasetprovider+clientdataset+datasource时
adoquery.sql.text=select * from table1 正常
adoquery.sql.text=select count(*) from table1 抛出如题错误,请高人帮忙!!!
adoquery.sql.text=select * from table1 正常
adoquery.sql.text=select count(*) from table1 抛出如题错误,请高人帮忙!!!
count(*)代表table1的什么呢?
clientdataset1.Active:=false;
clientdataset1.Active:=true;
//出错adoquery1.SQL.Text:=select * from lpmast; //lpmast 表名
clientdataset1.Active:=false;
clientdataset1.Active:=true;
//正常
改为select count(*)as Id from table1
试试
procedure TForm1.Button1Click(Sender: TObject);
begin
datasetprovider1.DataSet:=adoquery1;
Clientdataset1.ProviderName:=datasetprovider1.Name;
datasource1.DataSet:=Clientdataset1;
dbGrid1.DataSource:=datasource1; adoquery1.ConnectionString:='Provider=OraOLEDB.Oracle.1;Password=pcafis;Persist Security Info=True;User ID=pcafis;Data Source=afis';
adoquery1.SQL.text:='select count(*) from tpmast';
clientdataset1.Active:=false;
clientdataset1.Active:=true;
end;
我只想得到统计结果在Clientdataset1中,有别的方法吗?请给出简单的脚本,谢谢!!