>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?
Don't use ALIAS in RecNo():
select *, recno() as Rec1 from table1 into cursor tmp1
Not a good idea to use RECNO(). Why you need it?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.