Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Select .......into..............
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00692601
Message ID:
00692604
Vues:
21
>Is there any way I can have the inedx tags defined on a table added to the cursor created with a select SQL statement.
>
>eg. Select * from Mytable where fieldA='123' into cursor MyCursor
>
>if fieldA is indexed, can I make the fieldA in MyCursor indexed too?
>
>Thanks.
>
>Ria

Select....into cursor...
index on (field_name) tag (tag_name)

If you need more than one index, then you need to do the trick:
Select....into cursor My2Cursor
use (dbf("My2Cursor")) again in 0 alias mycursor
sele mycursor
index on....
index on...
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform