Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Views and indexes
Message
De
11/11/1998 15:49:01
Jim Rieck
Quicken Loans/Rock Financial/Title Sourc
Livonia, Michigan, États-Unis
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00156709
Message ID:
00156752
Vues:
34
How then?

>You bet.
>
>>Is it possible to set an index on more then one field?
>>
>>Jim
>>
>>
>>>you need to index on a FIELD in quotedet - not the view name iteself
>>>
>>>
>>>>This is what I did in the init event of the form.
>>>>SELECT quotedet
>>>>CURSORSETPROP("Buffering",3,"quotedet")
>>>>INDEX ON quotedet TAG part_num
>>>>
>>>>It says variable quotedet is not found.
>>>>
>>>>Any ideas?
>>>>
>>>>
>>>>>>Is it possible to create an index on a view? If so how?
>>>>>>
>>>>>>Thanks
>>>>>>
>>>>>>Jim
>>>>>
>>>>>The same way as on table (you should set view buffering=3):
>>>>>SELECT Myview
>>>>>INDEX ON Myfield TAG Myfield
Thanks

Jim
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform