>? lvRetVal.Fields(0).Value
>gives me
>"Member FIELDS does not evaluate to an object" error.
>
>>I never thought second is supposed to work. Where does it say it should work?
>Microsoft ADO help file "C:\Program Files\Common Files\Microsoft Shared\OFFICE11\1033\ADO210.CHM"
>Connection Object - bottom of the page
>"Execute a stored procedure as a native method of a Connection object
>
>To execute a stored procedure, issue a statement where the stored procedure name is used as if it were a method on the Connection object, followed by any parameters. ADO will make a "best guess" of parameter types. For example:
>
>Dim cnn As New ADODB.Connection
>...
>'Your stored procedure name and any parameters.
>cnn.sp_yourStoredProcedureName "parameter"
>"
In your stored procedure:
replace return 33 with select 33 and it should work.
Cetin