>>You can index a view. I also suggest that you check out a public domain grid class called INGRID that gives you incremental search capabilities in a grid.
>>
>>Craig
>
>It was I that asked about indexing a view the other day, and the response that I got was that no, you couldn't but you could base your grid on a table that was written at runtime from the view and then index that. This is impractical for me, as the view I need indexed is about 100.000 records. Is there another way?
100,000 records??? That seems like way too many to see in a view. A view is just like any cursor created with a SQL SELECT statement except that it is read/write. You should try to limit the number of records returned to the view.
Short of indexing, which is required to do a SEEK, the only other thing you can do is a LOCATE.
Craig
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer