Information générale
Catégorie:
Codage, syntaxe et commandes
>Hi John...
>
>
>ADO actually has this problem licked.... ADO Recordsets have both a bookmark and an absolute positon property.
>
>In your case, I would suggest using a local view that uses an order by. Then, you can create an index on the field you are actually ordering by - supporting seeks. Now, the record number and the relative position in the table will be in sync.
Thanks for the reply John. Your solution will work but I was looking for a way to do it in code so I didn't have to make special considerations for the views or tables. Craig Berntson has come up with a solution that will fill the bill.
Thanks for the help
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement