Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>I would like to create a SQL query in which one column contains a counter that increments by one for each record in the query result. This would be just like the count function which can be set for a report in the report designer. However I can't seem to find any function that would generate the numbers into the query result. As this must have come up at other times, I am hoping that some one might be able to give me an idea in this regard.
>>
>>Thanks
>>
>>Porter Bailey
>
>Why can't you use RECNO() of the resulting cursor?
Craig
I have tried Recno( ), however it comes up with the record number of the underlying table record, not the record number of the cursor. I think it was from there. It wasn't a sequential series of numbers anyhow.
PB
Précédent
Suivant
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