SAXONICA |
sql:insert
performs an SQL INSERT statement. This causes a row to be added to the table identified
by the "table" attribute. There is a mandatory connection
attribute, used as in the sql:query
instruction described above.
sql:column
is used as a child element of sql:insert
, and identifies the name and value of a column
to be included in the INSERT statement. The name of the column is identified by the name
attribute,
the value may be indicated either by evaluating the expression contained in the select
attribute, or
as the expanded contents of the sql:column
element. The value is always interpreted as a String.
(Remember this is purely a demonstration of extensibility, in a real system there would be a need to
cater for SQL columns of other data types).