Forums
This topic is locked
Changing the Cursor Type
Posted 11 Jan 2007 01:03:12
1
has voted
11 Jan 2007 01:03:12 Phil Grimpo posted:
I noticed that recently, when I select my recordsets, I can no longer change parameters, such as the Cursor Type. It appears that this is because DW is now using ADODB.Command which does not allow the Cursor Type to be changed. Is there a way to make this work differently? I'm trying some nested repeates and I need a dynamic cursor, rather than the default forward. Ideas?
It looks like ADODB.Command is used for regular recordsets and Stored Procedures. Why the change?
Thanks!
Phil Grimpo
Executive Director
Inspirmedia