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.)
Oil, Gas & Electric Companies That Use Stylus Studio
Oil, gas & electric companies know a good resource when they see it. That's why they use Stylus Studio as their #1 XML resource. Come see which of these top oil, gas & electric companies are conserving their time and labor with Stylus Studio.
Building Web Services With Stylus Studio
This video demonstration shows you how to use Stylus Studio's Web Service call composer to locate a WSDL file on the Internet, inspect, create SOAP envelope, invoke and inspect Web service data.
Using DTD in Java Applications
Learn how to validate XML documents using industry-standard DTD's from within your Java applications using Java DTD components including Apache Xerces and XSV.
Scientific, Photo & Control Equipment
Scientific, photo & control equipment companies hear clicks and beeps all day. But, when it comes to data integration it needs to be done in a flash, that's why they use Stylus Studio. Come see which top companies are seeing XML in a brand new light!
