Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Indexseek with view
Message
From
14/08/2002 10:31:44
Jason Mesches
Ocean Systems Engineering Corporation
Carlsbad, California, United States
 
 
To
14/08/2002 08:53:39
General information
Forum:
Visual FoxPro
Category:
The Mere Mortals Framework
Miscellaneous
Thread ID:
00688695
Message ID:
00689559
Views:
26
Nerissa,
These are two separate indexes you're creating, and you can only have one index as the "current" one at any given moment. When you create the second index, ObjectID, it becomes the current one.

If you want to switch the current index, use the cSet class:
**Note the use of a local variable.  This way,
** when the object goes out of scope and 
** destroys, the cSet object will reset your 
** index order to its previous value.
LOCAL loOrder
loOrder = CREATEOBJECT('cSet', 'ORDER', 'ParentID')
Hope that helps,
---J

>Are you saying that my view field in the 'Order by' is not the cause of the problem? But I already have two indexes in my view.
>
>This.createindex('v_dbaseinfo','INDEX ON parentid TAG parentid')
>This.createindex('v_dbaseinfo','INDEX ON objectid TAG objectid')
>
>Do I really need these two indexes and are they in the correct order? Should I not make 'objectid' comes before 'parentid'?
>
>Thanks a lot again.
>
>Nerissa
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform