I'm having trouble retrieving the return value from a sybase stored procedure. I'm using ADO from a VB client with a Connection, Recordset and Command onjects. I'm adding a parameter to the Command list with a direction of adParamReturnValue. However this doesn't return the value from the stored proc.
Does anyone have any ideas about how to get the return value.