Multiple queries in one transaction

[maciejkaczkowski]

Is possible to put few inserts and updates in one transaction. SQLite code looks like this:

Code: Select all

with Query.SQL do
begin
  Add('INSERT INTO abc VALUES (''aa'');');
  Add('INSERT INTO abc VALUES (''bb'');');
  Add('INSERT INTO abc VALUES (''cc'');');
  Add('COMMIT;');
end;
Query.ExecSQL;

The same code doesn't work at FB (1.5/2.0). What I should change?

[zippo]

I think it can be done via a special component called ZSequence or ZProcessor (can't remember and didn't used it until now).

[bangfauzan]

zippo is right, as far as I know, we can make multiple statements using ZProcessor or ZSequence, but we can't do that using ZQuery.

[mdaems]

It's ZSqlProcessor.
ZSequence is for getting sequences from the server (eg using nextval() for Oracle)

Mark

[maciejkaczkowski]

Now everything works fine.