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.)
Insurance Companies That Use Stylus Studio
Everyone needs insurance, even insurance companies. That's why these top insurance companies are insured when it comes to XML. Come see which insurance providers are insured by the power of Stylus Studio!
Computing XML Differences in Stylus Studio
See for yourself just how easy it is to visually compare different XML files or folders using Stylus Studio's powerful new XML Differencing Utility. Quickly and easily analyze and merge changes made to different XML documents!
The XML Primer: Editing and Validating XML in Stylus Studio
The XML primer demonstrates editing and validating XML in Stylus Studio demonstrates XML editing tools and utilities to simplify working with XML documents. Learn how to automate XML editing operations and troubleshoot XML documents today!
Technology Companies That Use Stylus Studio
Technology companies can't always handle every technology that they come across. That's why when it comes to XML, they look to Stylus Studio to guide them. Check out which top technology companies are looking to the future with Stylus Studio.
