Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Error 1548 Close Non Structural Index at BEGIN TRANSACTI
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00301145
Message ID:
00301156
Vues:
31
>I'm getting Error 1548 when attempting a BEGIN TRANSACTION in some code after I have ran a report from a View and I want to update the records in the view.
>
>Prior to the Transaction I INDEXed the View so that I could SET RELATION to the header records from the detail records for the report. However, it won't let me use the BEGIN TRANSACTION command. It still runs the code as if it was in a Transaction but I'm sure the ROLLBACK would error because the END TRANSACTION errors.
>
>Any ideas what I'm doing wrong?
>
>TIA

Sounds like you are doing an INDEX ON SOME_FIELD TO MYINDEX which creates a non-structural index [IDX]. Do INDEX ON SOME_FIELD TAG MYINDEX which creates a structural index [CDX].
Mark McCasland
Midlothian, TX USA
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform