>Dear Experts
>
>I have this select statement
>
>select name,country from mytable order by name into cursor xyz
>
>It displays following data
>
>Abc----India
>Bush---Germany
>Eric---japan
>
>I want to show display (record number) serial number in other column as
>
>1---Abc------India
>2---Bush---Germany
>3---Eric------japan
recno() seems appropriate. Make sure you select into cursor with the NOFILTER option, otherwise you might get the record numbers from the underlying table.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)