Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Non-structural index open on BEGIN TRANSACTION
Message
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00097262
Message ID:
00097420
Views:
18
>>I get, not every time, but often enough to cause great concern, an error message that is generated when the BEGIN TRANSACTION statement is issued that some view (not always the same one) of mine has an open non-structural index file open. I do not create any non-structural indexes (implies use of OF CDXfilename in the index command which I never use) for my views and these views are not going to be part of the transaction. I need to get around this error message and let these transactions progress. Private Datasessions, pessimistic buffering, view not part of the update but loaded in the DE and not buffered.
>>
>>Steve
>
> Steve -
>
>Is it possible you have a temporary IDX created? For example, are you using a framework that gives you the ability to sort by double clicking on a column header? This will also give you this message.
>
>- Mark

That should be impossible, but should be and reality can be two different things. I build indexes on the fly in only one instance. That's within a self building grid that has searching capabilities. The .MakeIndexes method simply issues an INDEX ON &Something TAG (Something) command and that's it. All other indexes are associated already with the table definitions.
I don't do any indexing within the application anywhere else. These grids are used with view definitions on a couple of forms. No commercial framework but my own developed in house. Yes, you can click on the grid's header but it doesn't index then, the view was already indexed when the grid did it so the tag already exists.

Steve
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform