>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