Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Views and indexes
Message
De
11/11/1998 16:06:05
 
 
À
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:
00156765
Vues:
37
index on field1 tag field1
index on field2 tag field2
etc.

or if you're talking about in one index - you can index on expressions like ..

index on field1+field2 tag mytagname

>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
Ken B. Matson
GCom2 Solutions
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform