setting a recordset cursortype to adOpenStatic when executing a parameter query

[Matthew Harad]

hello,

i am executing a parameter with queries by using the
command ADO object. however, i want to be able to use the
find method with the resulting recordset. is this
possible? i can't seem to get it to work -- even if i try
to set the cursortype on the recordset to adOpenStatic
ahead of time it reverts to adMoveForwardOnly after i
execute the query.

much thanks!!

 

[Jim Vita]

Matthew,

Try adding the cursor location option adUseClient.

Thanks,

Jim

Jim Vita
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.