User Guide

Advanced topics in data integration 289
For a typical workflow and information on the methods, properties, and events of the
RDBMSResolver class, see “Using the RDBMSResolver component (Flash Professional only)”
and “RDBMSResolver class (Flash Professional only)” in Using Components.
In addition to requirements for your Flash application to resolve data, there are requirements for
your server code to fulfill. For more information, see “Server-side requirements for resolving data
for RDBMS” on page 304.
For a tutorial that uses the RDBMSResolver component, see the DevNet article “Using the
RDBMSResolver to Update a Database” at www.macromedia.com/devnet/mx/flash/articles/
delta_packet.html.
Formatting your results (Flash Professional only)
By default, the resolver components use the schema specified on the connector components to
format values sent to the server. This method ensures that a date value sent from an external data
source using the format “MM/DD/YYYY” is sent back to the external data source using the
same format.
However, in some cases, you might find that the values you’re sending to your external data
source are not formatted correctly. This can occur when you don’t use a connector to retrieve
your data or you want to change the format of the data to be sent to an external data source. In
this case, you can control the formatting by adding properties to the resolver component’s
schema. For instance, if you have a Boolean field called Billable in your DataSet component, its
value can be formatted in an update packet as
true or false. If you want it formatted as yes or
no, you can create a new component property called Billable within the Schema tab for your
resolver. Using the schema settings, you can set the data type as Boolean, the encoder as Boolean,
and the encoder options as
yes or no. The encoder is applied when the resolver creates the update
packet, and the value for the billable field is represented as
yes or no.
For more information, see “Adding a component property to a schema” on page 262.
Advanced topics in data integration
This section discusses advanced topics, such as refinements you make to schema settings and
information for developers who need to write server-side code to interact with Flash data
applications.
Schema item settings
This section contains details about schema item settings and how you edit them. To help you
determine whether or not you need to look at schema item settings, see “When to edit schema
item settings” on page 300.