>>>Hi
>>>
>>>I have a grid whose data is a cursor - I search the grid by client and the search works OK
>>>
>>>How do I make the record I have found become the top record in the grid?
>>
>>Add another field to the cursor called toprecord. When creating the cursor, set toprecord to "9" for all records.
>>
>>Index the cursor on toprecord + clientname (or whatever).
>>
>>Once you determine which record should be on top, set toprecord = 1 for that record and refresh the grid.
>
>A slick technique. Kudos. I wonder, though, whether it might confuse users. They must think they are viewing the records in the grid in some order, and then some other record pops to the top of the list. Just thinking out loud....
I was just suggesting a way to do what he asked for. I don't like doing that to a user either - confusing for sure.
>
>So what's new in Kansas? As you may have noticed, I am spending most of my time only one state away. In fact the company where I am working in St. Louis has a second, smaller, office in KC. Some of the execs in the KC office show up here from time to time.
Only news around here is that I'm not spending most of my time in KC now. This drops my daily commute to about 60mi round trip vs 200 when I was working in KC. Much better!
What are you doing in St Louis?
____________________________________
Don't Tread on Me
Overthrow the federal government NOW!
____________________________________