I am having trouble implementing ado filter and sort on a recordset returned from a stored procedure.
The following 2 lines are the same for both adUseClient and adUseServer.
prsCommissions.CursorType = adOpenStatic
prsCommissions.LockType = adLockOptimistic
I found that if I use a client side record set like this:
"prsCommissions.CursorLocation = adUseClient" that the recordset does not update, but does sort and filter.
If I use a server side recordset like this:
"prsCommissions.CursorLocation = adUseServer" that the recordset updates, but does not sort or filter.
What is the best practice when using stored procedures to retrieve updatable recordsets that can be filtered and sorted?
Thanks in advance!
July 28, 2005 1:45 PM
July 28, 2005 2:43 PM