Click to See Complete Forum and Search --> : SQL Stored Procedure recordsets. Which type?


Keith Greeley
October 18th, 1999, 10:07 AM
I have opened a Recordset from a SQL stored procedure
within an ODBC workspace using :

Set rsTemp=conPubs.Openrecordset("pr_vb_test", dbOpenDynamic)

I have chosen all the various dbOpenDynaset, dbOpenSnapshot..parameters etc., but no matter which one I choose, I cannot use the MoveFirst, or various other methods on this Recordset without receiving the 'Invalid operation 3219' error. The recordset I know is NOT empty. Can anyone advise me on why this is?
Thankyou in advance