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