Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
View with an index problems
Message
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
01136529
Message ID:
01136749
Views:
120
The error points to existence of non-structural indexes on the table and you are trying to delett the structural indexes.

>I've got a real doozy here. Not sure how I caused it as it was working yesterday... (ya'll know how that goes). Here's what little detail I can provide about the errors I'm getting.
>
>The method I'm dealing with starts with a call to a save function that starts and ends a transaction. When the BEGIN TRANSACTION is issued in the save I get an error:
>
>Error 1548: Table myview has one or more non-structural indexes open. Please close them and retry the Begin Transaction.
>
>So... ok, I'll get rid of the tags before calling the save, like so:
>SELECT ( tcView )
>IF !EMPTY( TAG( 1 ) )
> lcSafety = SET( 'safety' )
> SET SAFETY OFF
> DELETE TAG ALL
> SET SAFETY &lcSafety
>ENDIF
>
>Which, surprise, nets me this error:
>
>Error 26: Table has no index order set. (on my DELETE TAG ALL line)
>
>Next logical step would be to set an order then. "SET ORDER TO 1" gets placed prior to the DELETE TAG ALL. Running this nets the same error in the same place.
>
>If anyone's ever seen this before and figured out what was going on... please let me know. About to tear my hair out.
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform