Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
One or more non-structural indexes open, please close
Message
From
28/09/2001 14:27:09
Jason Mesches
Ocean Systems Engineering Corporation
Carlsbad, California, United States
 
 
To
28/09/2001 11:27:57
Rex Mahel
Realm Software, Llc
Ohio, United States
General information
Forum:
Visual FoxPro
Category:
The Mere Mortals Framework
Miscellaneous
Thread ID:
00561946
Message ID:
00562025
Views:
35
Yep, seen this... bought the shirt...

We fixed this in the framework... actually Gar Lipow had the solution here on the thread awhile back, I brought it to Kevin's attention, and he added it to the latest framework.

Anyhow, here's the solution: In the DataEnvironment's PostInitHook() call: This.CreateIndex(YourAliasName, YourIndexExpression (e.g. "INDEX ON iID TAG iID"))

This makes sure that the index is either created from scratch or added to an existing structural index "file."

That should fix the problem.
---J

>All,
>
>I have a form based on cListObjEditForm. I add a record and save. I then edit the same record and change something and save again. The record does not save that time, I get:
>
>Error # 1549
>
>Table <> has one or more non-structural indexes open. Please close them and retry the Begin Transaction.
>
><> is the cListObj view from the parent form. It has an index, but it is not non-structural.
>
>Has anyone encountered, and hopefully fixed, this problem.
>
>Thanks
>
>Rex
Previous
Reply
Map
View

Click here to load this message in the networking platform