>Hi All,
>
>Is it possible to seek a record in a cursor, I can't seem to do this and was hoping for some guidance.
>
>Here's the sql in my grids recordsource:
>
>select name, yr_bred from master where type = "B" order by name into cursor addfoal noconsole
>
>The grids recordsourcetype is set to 4-SQL statement.
>
>There is a textbox on the form where the user may enter the record they desire and I would like for them to be able to "Seek" the record but I'm getting a "table not indexed" message.
>
>The idea would be for the grid to be refreshed with the record being "seeked" showing up in the middle of the grid itself.
>
>The sql creates a cursor with about 15,000 records from a table of 23,000+.
>
>Any help would be appreciated.
>
>Thanks,
>
>Jim Harvey
>jharvey@netrax.net

In order to issue a SEEK on a recordset, there has to be an index on the field.