WIth ADOQuery1 DO BEgin Close; SQL.Clear; SQL.Add(' SELECT MAX(bianma) as aa FROM ka_fl'); OPen; dbedit1.DataField:='aa'; 没有问题的呀 是不是你的dbedit1.DataField:='aa'写的位置不对呢 我刚刚试验的你在参考一下吧
angle097113(深思不解) 说得是呀,你仔细看看吧
Form2.SimpleDataSet1.DataSet.Active:=False; Form2.DBEdit1.DataField:=''; Form2.DBEdit1.DataSource:=Form2.DataSource1; Form2.SimpleDataSet1.DataSet.CommandText:='select max(mainidexp) as aa from card_info where maindid='+''''+tmp+''''; Form2.SimpleDataSet1.Open; Form2.DBEdit1.DataField:='aa';代码如上,提示字段aa不存在。我是在Form7调用的。
ADODataSet1.Close; ADODataSet1.CommandText:=''; ADODataSet1.CommandText:='SELECT MAX(bianma) AS aa FROM ka_fl '; ADODataSet1.OPen; DBEdit1.DataField:='aa'; 没有问题的又测试了的 Form2.SimpleDataSet1.DataSet.CommandText:='select max(mainidexp) as aa from card_info where maindid='+''''+tmp+''''; 这个语句就编译不过 dataset 应该去掉 改为 Form2.SimpleDataSet1.CommandText:='select max(mainidexp) as aa from card_info where maindid='+''''+tmp+'''';
先设置datasource 再设置datafield
BEgin
Close;
SQL.Clear;
SQL.Add(' SELECT MAX(bianma) as aa FROM ka_fl');
OPen;
dbedit1.DataField:='aa';
没有问题的呀 是不是你的dbedit1.DataField:='aa'写的位置不对呢
我刚刚试验的你在参考一下吧
Form2.DBEdit1.DataField:='';
Form2.DBEdit1.DataSource:=Form2.DataSource1;
Form2.SimpleDataSet1.DataSet.CommandText:='select max(mainidexp) as aa from card_info where maindid='+''''+tmp+'''';
Form2.SimpleDataSet1.Open;
Form2.DBEdit1.DataField:='aa';代码如上,提示字段aa不存在。我是在Form7调用的。
ADODataSet1.CommandText:='';
ADODataSet1.CommandText:='SELECT MAX(bianma) AS aa FROM ka_fl ';
ADODataSet1.OPen;
DBEdit1.DataField:='aa';
没有问题的又测试了的
Form2.SimpleDataSet1.DataSet.CommandText:='select max(mainidexp) as aa from card_info where maindid='+''''+tmp+'''';
这个语句就编译不过 dataset 应该去掉
改为
Form2.SimpleDataSet1.CommandText:='select max(mainidexp) as aa from card_info where maindid='+''''+tmp+'''';