ADO, Visual Basic and SQLOLEDB

[Lozzer]

I am trying to open a static, pessimistic locking recordset on a SQL 7 server which needs some record deletions.

I need also to order the recordset and have been trying to do so by using an order by clause in the SQL statement in the open method of the recordset.

If I remove the ORDER BY clause the recordset opens fine.

If I use the ORDER BY clause, the recordset returned is always read only and forward only!!

Does anyone have any ideas how to get around this problem??
PLEASE HELP!!

 

[Foada]

You have to change your cursor to something besides static. This is a forward only cursor. If you choose to battle wits with the witless be prepared to lose.