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.)
XML-DEV Discussion Forum
XML-DEV is a leading technical forum for XML discussion and a valuable free XML learning resource. Subscribe to the XML-DEV email discussion forum today to help further your XML education.
Open XSLT Architecture
Learn how Stylus Studio's Open XSLT Architecture enables you to use any of the popular industry-standard XSLT processors (like Saxon, Xalan-J, MSXML, Microsoft .NET, and others) for all your XSLT development tasks.
Advertising & Marketing
Learn about top advertising and marketing companies that are leveraging Stylus Studio 2006 to enhance their everyday work experience.
Binary XML
How do I get my binary data into XML? How do I get my binary data out of XML? The answers to these questions and more in this amazing Binary XML tutorial.
