>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
>
>Please help
That recno() is recno() of xyz, right? Simply add a new column and set its controlsource to:
(recno('xyz'))
In code it would be:
thisform.myGrid.AddColumn(1)
thisform.myGrid.Columns(thisform.myGrid.ColumnCount).ControlSource = '(recno("xyz"))'
Cetin