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
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