BEGIN/COMMIT errors (solved)

[veneff]

I am getting an error whenever I execute the COMMIT query.
The program flow is
Query = "BEGIN TRANSACTION"
Query = "UPDATE..."
Query = "INSERT..."
Query = "COMMIT"

At this point I get the error:
"SQL logic error or missing database"
This sequence works OK in LB4.
I don't disconnect from the database until after the "COMMIT".

Vance

[kokenge]

commit needs to be:
Query = "COMMIT TRANSACTION"

[veneff]

Thank you!

That was the problem. For some reason I though that the word TRANSACTION was optional.

Vance