Sorting of a DataBase
Posted on 1998-09-08
I have built a database from VB5.0.
Now, I try to do the sorting of the data of the database
by using the function -- CDaoRecordset::m_strSort
The remarks of this topic mentioned that:
Contains a string containing the ORDER BY clause of an SQL statement without the reserved words ORDER BY. You can sort on dynaset- and snapshot-type recordset objects.
Now I have a dynaset recordset objects. How can
I sort the specified column of my Database by the above
function or any other good method to implement this?
The fields of my database are as follows:
Direct Number, Extension Number, First Name, Last Name
I want to do the sorting for the direct number.