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 (
|
)
). 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.)
FLWOR - An Introduction to the XQuery FLWOR Expression
An XQuery FLWOR Tutorial, covering an introduction to the main constructs of the XQuery FLWOR expression, including: For, Let, Where, Order By, and Return. Written by the W3C's Dr. Michael Kay.
Stylus Studio Product Documentation
Stylus Studio product documentation consists of The Stylus Studio User's Guide, An online Help system, Release Notes to keep you up to date with Stylus Studio's continuing innovations and enhancements.
Why XQuery - The Case for XQuery
Read "The Case for XQuery" - an article that debuted in the November 2005 issue of SOA WebServices Journal, written by Jerry King, Vice President of DataDirect Technologies.
Create XML Schema from XML Content
Create XML Schema from XML Content by auto-generating an XML Schema with Stylus Studio.
