Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Seek record in cursor
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00410485
Message ID:
00410505
Vues:
13
Why not just index the cursor as you would any other table.

>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform