Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error 1548 Close Non Structural Index at BEGIN TRANSACTI
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00301145
Message ID:
00301156
Views:
32
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform