ddtek:sql-delete


This built-in function deletes records in a database table.

The syntax is:

declare updating function ddtek:sql-delete( 
    row as element()*) external; 

where:

row identifies the records to be deleted. Each item in the sequence must be a row element of the database table returned by a previous fn:collection() call.

The following example deletes all of the records in the holdings database table where the userid column equals Minollo.

ddtek:sql-delete(collection("holdings")/holdings[userid = "Minollo"]) 

Other examples can be found in the RDBMSUpdate example.