>We are putting a Fox 6 front end on SQL 7.
>We would like to do incremental searches on wide tables. To do so we create a 2 field remote view from the table. Is there a way to do an optimized incremental search on the view?
>
>Obviously, in Fox, we index on a field and SEEK() on that field.
>Views are different, I assume? Any hints?
You can create indexes on the fields in the views that need to be searched. Otherwise, I just use a LOCATE statement which is obviously not optimized. But on small record sets, the performance has been acceptable for me when I do this.
Mark McCasland
Midlothian, TX USA