>Dear ALL,
>
>I would like to include the recno of individual record by
>

>select *, recno('table1') as Rec1 from table1 into cursor tmp1
>

>
>instead of the Record No., it appeared as total record count. Any idea?

RECNO(), without alias, it is reliable only in projection list and
when the FROM have 1 table only.

A example, where it fail:

select *, recno('renametable') as Rec1 from table1 renametable into cursor tmp1