Retrieving Data Using SQL

[pradeep_sai]

Hi there!
I need to retrieve the return value of an SQL Statement to a variable. The SQL statement looks like this

SELECT MAX(SAL) MSAL FROM EMP

the return value should get bound into a variable in VB. Can any one help me in tracing a way out.

[monte96]

If you open your query using a recordset, the value will be in recordset.fields(0)

[pradeep_sai]

But i am Using RDO for accessing database. therefore in case of resultset would it work? i.e., something like

resultset.rdocolumns(0)

to retrieve the value.

[monte96]

Not sure with RDO.. I would assume so..