Topic: SQL-button with multiple SQL-statements

Hello everyone,

how do I create a SQL-button with multiple SQL-statements?

I tried something like this:

BEGIN;
delete from nummer where id = "{IDlöschen}";
delete from history where idd = "{IDlöschen}";
COMMIT;

I Think the transaction is unable to stop and after pushing the button again it said:

"cannot start a transaction within a transaction"

Any advise?

Thanks!

Re: SQL-button with multiple SQL-statements

I think it's my bug, but so far I have not found a solution.

Dmitry.