OpenKeyset Recordset - ADODB
-
Hi there, Is there a way to determinate the cursor type of a recordset using the .Execute command of a ADODB.Command object? If you use a ADODB.Recordset object, you define the cursor type like this:
myRecordset.Open mySQLCommand, myDatabase, adOpenKeysetI now use stored procedures in my DB and I still want to set the cursor type to OpenKeyset, if that is possible... Thanks, WerriesA programmer's life is good... or is it?? Ek dink nie so nie!
-
Hi there, Is there a way to determinate the cursor type of a recordset using the .Execute command of a ADODB.Command object? If you use a ADODB.Recordset object, you define the cursor type like this:
myRecordset.Open mySQLCommand, myDatabase, adOpenKeysetI now use stored procedures in my DB and I still want to set the cursor type to OpenKeyset, if that is possible... Thanks, WerriesA programmer's life is good... or is it?? Ek dink nie so nie!
The cursor type won't change. Your SQL is still returning that same recrodset no matter if it's done by stored proc or by a SQL statement you pass in.
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007