Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Opening indexes more than one time in to data session
Message
From
29/01/2002 06:24:31
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00611786
Message ID:
00612059
Views:
24
>My index are not structural...

Why not? Structural indices have several advantages. The old-type IDX should only used in special cases, especially temp indices.

Hilmar.

>
>>If client.dbf has a client.cdx you should not have to set index to. Look at SET ORDER TO instead. Structural CDXs open with the table.
>>
>>>My probrem is:
>>>
>>>I have a form (Private data session) with a table (Client.Dbf) in the data environnement. In the Init sequence of the Cursor I open indexes (set index to cnum.cdx). When I click on my Add button, I perform a Cursorsetprop("Buffering",4) on the table.
>>>
>>>If I open the same form again, I get a "Command cannot be issued on a table with
>>>cursors in table buffering mode" on the Set index to Cnum.cdx command.
>>>
>>>If the Buffering mode is Row, all's ok.
>>>
>>>Is there a way to open the same index two times in two differents data session?
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform