>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?
SEEK only works if there's an index in place; if you want to use SEEK, you need to create an index on the cursor after creating it. You can either create a single index using INDEX ON...TAG on a read-only cursor, reopening the cursor for read/write will allow you to create mutliple TAGs. You can create as many IDX files on a read-only cursor as you like (each will be a separate .IDX file) but they will not auomatically disappear when the cursor is closed, unlike TAGs, which by dfault are a part of a structural .CDX which is cleaned up automatically.