Subject:ddtek:sql-delete and ddtek:sql-insert in the same XQuery ? Author:Minollo I. Date:02 Oct 2007 09:34 AM
It is possible to insert a row a delete *pre-existing* rows; you cannot delete the same row that you just inserted, as the underlying RDBMS changes become visible only when the XQuery execution is complete. If you need to do that, you'll have to split the logic in two separate XQueries.
If you just want to use sql-insert and sql-delete in the same XQuery, there is nothing strange syntactically speaking:
ddtek:sql-insert("table","name","pincopallo","age",99),
ddtek:sql-delete(collection("table")/table[name="evaristo"])
(inserts a new "pincopallo" row, and deletes any "evaristo" row).