Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Can I SEEK for nearest matched 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:
00247560
Message ID:
00247588
Vues:
28
>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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform