Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Views and indexes
Message
From
11/11/1998 15:45:53
Jim Rieck
Quicken Loans/Rock Financial/Title Sourc
Livonia, Michigan, United States
 
 
To
11/11/1998 15:43:33
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00156709
Message ID:
00156744
Views:
50
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform