Alex
Trouble is the original data to be shown in the grid won't necessarily be in record order, i.e. in an index order, so won't this have an inaccurate/meaningless row number in the grid? Not being 8-literate,. of course, I don't know what the Cast bit is doing though.
>Depending on row number is generally not a good design. If you want to show it, then you could add a column to your controlling cursor:
>
>* in VFP9
>Select f1,f2,Cast(0 as integer) as rownumber from MyTable Into Cursor dummy readwrite
>* in VFP8
>Select f1,f2,00000 as n(5,0) as rownumber from MyTable Into Cursor dummy readwrite
>
>* then
>replace all rownumber with recno()
>
>* now go to show grid...
>
>HTH
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.
