>All,
>
>I have a SQL Select for putting all my records in a cursor, and I need to do some search in the cursor.
>
>I''m be able to use LOCATE to look for a certain record but couldn't use SEEK or FIND because both of them need an index tag. I need to search for the nearest matched record in the cursor in case LOCATE fails.
>
>Any solution for this?
You can index once (and use SEEK) on a readonly SQL cursor. If you make it writeable, you can have more tags to SEEK on...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.