Hi,
is it possible to "stop" the SQLTransformer when an error occurs
while processing more than one query in a single transformation?
I have the following case:
[...]
<query>INSERT INTO foo (key) VALUES (1)</query>
[...]
<query>INSERT INTO bar (key) VALUES (1)</query>
[...]
(foo and bar have a 1:n relation)
The first query fails ("Duplicate key...") as the file 'key' is
declared as unique in the first table, but the query on bar gets
executed, which has some nasty side-effects.
Is there any way to stop after the query on foo, when an error occurs?
Thanks for you answers in advance.
Regards,
Benjamin
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
