>>>>>Hi
>>>>>
>>>>>I am searhing a file with 100 records on it - all the records are displayed in a grid
>>>>>
>>>>>When my search finds the record i want how do I display it at the top of the grid - and how do I give a dark blue backcolor to the line of the found item
>>>>>
>>>>>Colin
>>>>
>>>>Just put this row first in the order and highlight using dynamic back color and some extra field, say, lFound.
>>>
>>>Thanks but (stupid question) how do I put it first in the order
>>
>>Essentially like this, in pseudocode (if I remember correctly)
>>Yourform.Lockscreen=.T.
>>lnGridHeight=yourgrid.height
>>yourGrid.height=20
>>Locate for whatever
>>yourGrid.height=lnGridHeight
>>Yourform.Lockscreen=.F.
>
>thanks i will try
I actually meant something different, but I think this idea may also work. I meant
select .. order by lFound DESC, other fields
GO TOP
If it's not broken, fix it until it is.
My Blog