请教如何将SELECT得到的单一结果保存到一个变量中。(50分)

I

icommander

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-29

• #1

请教如何将SELECT得到的单一结果保存到一个变量中。

 

W

wwolf

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-29

• #2

rs.open "select 1+1";
i:=rs.field(0);

 

萧

萧寒月

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-29

• #3

...
query1.sql.add('select field1 as a,field2 as b from table1')
...
tmpa:=query1.fieldvalues['a']

 

I

icommander

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-03

• #4

thx.