General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>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.
>
>I would suggest using RecNo(). Are you positive you are doing Recno() on the cursor? Maybe try a NoFilter on the end of the SQL SELECT? If you need to, do this, but you sohuldn't have to:
>
>private pnRec
>pnRec = 0
>
>select NextRec() as rec, * .....
>
>function nextrec
>return pnRec + 1
If the table is ordered the Recno( ) will not work, i.e., what is in the count column is not the same as the cursor record number. This is also so with NoFilter at the end. I will try the function.
Thanks for your help.
PB
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only