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.
Printable View
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.
If you open your query using a recordset, the value will be in recordset.fields(0)
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.
Not sure with RDO.. I would assume so..