Cart|
Home > Online Product Documentation > Table of Contents > Understanding SELECT and UPDATE Understanding SELECT and UPDATEAs described previously, you define SQL/XML SELECT statements on the SELECT tab; you define INSERT and UPDATE statements on the UPDATE tab. The DB-to-XML data source simply presents the SQL/XML to the database. The database executes the SQL/XML to the best of its ability, based on the statements you have defined and the permissions of the user associated with the DB-to-XML data source. If the user has read-only permissions, for example, any INSERT or UPDATE statement will fail.
When Statements are Executed
Statements on the
SELECT tab are executed when you click the
Execute Query button (
|
XML PRODUCTIVITY THROUGH INNOVATION ™
)
). Statements on the
UPDATE tab, on the other hand, are executed only when an XML version of the DB-to-XML data source document is saved. (The
Execute Query button is disabled when the
UPDATE tab is active.)
