one database source insert to more than 1 table?

[t4nu]

Hi,
As far as I know, 1 database source can only insert or update or delete to 1 table. So if my transaction need to update to more than 1 table, what should I do so the data can be saved in all or none manners?
Call a stored procedure? execute query directly? or maybe there is other things that more simple?
Thanks in advance for the help.

[Segi]

Technically speaking, there's nothing stopping you from putting more than 1 SQL command in the insert update or delete tabs as long at both tables that are being modified are accessible by the database connection that you specify for the database resource.

so you could have this in the insert tab

UPDATE Table1 SET column1='foo' where id=1234
UPDATE Table2 SET column2='bar' where id=1234

[Jon]

Or just add another database resource for the second insert, they will both be executed within the same transaction.

[t4nu]

Hi,
Unfortunately the code (following your example) gave me:
SQL command not properly ended error message.

The same message when I put the ; in the end of the command.

Technically speaking, there's nothing stopping you from putting more than 1 SQL command in the insert update or delete tabs as long at both tables that are being modified are accessible by the database connection that you specify for the database resource.

so you could have this in the insert tab

UPDATE Table1 SET column1='foo' where id=1234
UPDATE Table2 SET column2='bar' where id=1234

[t4nu]

Ah really?
If this is the case (execute 2 database resource but still in the same transaction) maybe this approach can become another alternative.
Thanks.

Or just add another database resource for the second insert, they will both be executed within the same transaction.