1. Add a field that will store the #
2. Run the query
SELECT 0000000000 AS SeqNum, &lcFieldList FROM ... into cursor CC WHERE &which
3. Open cursor R/W and replace SeqNum with RECNO()
SELECT 0
USE DBF("cc") AGAIN ALIAS ccsn
REPLACE ALL SeqNum WITH RECNO()
>
>How to put sequential (row) number in select counstruct like:
>
>SELECT &lcFieldList FROM ... into cursor CC WHERE &which
>
>CC ( 1, .. )
>CC ( 2, .. )
>
>TIA, gojko
--sb--