取第一条: adoquery.close; adoquery.sql.text:='select aa.nextval as temp from dual'; adoquery.open; ShowMessage(adoquery.FieldByName('Temp').AsString);
提示我fieled 'temp' not found???
取一条记录中所有数据 adoquery.close; adoquery.sql.text:='select aa.nextval as temp from dual'; adoquery.open; for i:=0 to table1.Fields.Count-1 do ShowMessage(adoquery.Fields[i].AsString);
adoquery1.close; adoquery1.sql.text:='select aa.nextval f_temp from dual'; adoquery1.open; ShowMessage(adoquery1.FieldByName('f_Temp').AsString);上面的代码没有道理不行的呀。。
adoquery1.close; adoquery1.sql.text:='select aa.nextval f_temp from dual aa '; adoquery1.open; ShowMessage(adoquery1.FieldByName('f_Temp').AsString); 应该没问题了
对不起,没看清楚,更正一下: adoquery1.close; adoquery1.sql.text:='select aa.nextval as f_temp from dual'; adoquery1.open; ShowMessage(adoquery1.FieldByName('f_Temp').AsString);上面的代码没有道理不行的呀。。
adoquery.close;
adoquery.sql.text:='select aa.nextval as temp from dual';
adoquery.open;
ShowMessage(adoquery.FieldByName('Temp').AsString);
adoquery.close;
adoquery.sql.text:='select aa.nextval as temp from dual';
adoquery.open;
for i:=0 to table1.Fields.Count-1 do
ShowMessage(adoquery.Fields[i].AsString);
adoquery1.sql.text:='select aa.nextval f_temp from dual';
adoquery1.open;
ShowMessage(adoquery1.FieldByName('f_Temp').AsString);上面的代码没有道理不行的呀。。
adoquery1.sql.text:='select aa.nextval f_temp from dual aa ';
adoquery1.open;
ShowMessage(adoquery1.FieldByName('f_Temp').AsString);
应该没问题了
adoquery1.close;
adoquery1.sql.text:='select aa.nextval as f_temp from dual';
adoquery1.open;
ShowMessage(adoquery1.FieldByName('f_Temp').AsString);上面的代码没有道理不行的呀。。