General information
Category:
Coding, syntax & commands
This is a kludge but it works. Except in the case of a select from only one table, there is no way to get the correct recno(). Try this, however:
select *,recno() as rn1 from table1 into cursor tabl1
select *,recno() as rn2 from table2 into cursor tabl2
...
...
...
Now do the same multiple table select as you would have only using tabl1, tabl2, etc. rather than the original tables. The resulting cursor/table will have the correct record numbers from the base tables as rn1, rn2, etc.
HTH
>Is there any way to have SELECT selects RECNO()? TO make it harder I have more then one table in this SELECT statement.
>TIA Mark
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