Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
View with an index problems
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Titre:
View with an index problems
Divers
Thread ID:
01136529
Message ID:
01136529
Vues:
65
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.
Chris Zangarine
Software Development Engineer
Pipeline Compliance System (PCS)
American Innovations
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform