Click to See Complete Forum and Search --> : SORTING in ADO Recordset located in the Server?????


October 22nd, 1999, 06:34 AM
I´m programming attaching a SQLserver 7.0 database, using ADO.

Can you tell me a way to sort an ADO recordset with adLocation property = adUseServer (it´s necessary for me, cannot locate in Client, i need to see changes) with the sort method?

I think i cannot do this if location is aduseserver.
But do you know how could i do it without launching SQL query again, i mean, using the same recordset?


Thank you