>Thanks,
>
>What is the difference between a RecordSet and a RdoResultSet? How would you re-order a RdoResultSet?
>
>Nick
VB offers 3 main ways of accessing data:
-DAO (which has a recordset object) - old technology focused on Access.
-RDO (which has a resultset object) - old technology focused on SQL and Oracle.
-ADO (which also has a recordset object) - the newest of these 3.
Each object is giving you different properties, methods and events. The sort method is only available when using ADO.
When using RDO, you need to go back to the data to have them resorted.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com