User Guide

RDBMSResolver component (Flash Professional only) 637
umUsingKey The default value. This setting uses the old value of the key fields. This implies
an “optimistic concurrency” model, which most database systems today employ, and
guarantees that you are modifying the same record that you retrieved from the database. Your
changes overwrites any other user’s changes to the same data.
NullValue is a string representing a null field value. You can customize this parameter to prevent
it from being confused with an empty string (
"") or another valid value. The default value is
{_NULL_}.
FieldInfo is a collection representing one or more key fields that uniquely identify the records. If
your data source is a database table, the table should have one or more fields that uniquely key the
records within it. Additionally, some fields may have been calculated or joined from other tables.
Those fields must be identified so that the key fields can be set within the XML update packet,
and so that any fields that should not be updated are omitted from the XML update packet.
The FieldInfo parameter lets you use properties to designate fields that require special handling.
Each item in the collection contains three properties:
FieldName Name of a field. This should match a field name in the DataSet component.
OwnerName Optional value used to identify fields not “owned” by the same table defined in
the RDBMSResolver components TableName parameter. If this property has the same value as
the TableName parameter or is blank, usually the field is included in the XML update packet.
If it has a different value, this field is excluded from the update packet.
IsKey Boolean property that you should set to true so that all key fields for the table
are updated.
The following example shows FieldInfo items that are created to update fields in a customer table.
You must identify the key fields in the customer table. The customer table has a single key field,
id; therefore, you should create a field item with the following values:
FieldName = "id"
OwnerName = <--! leave this value blank -->
IsKey = "true"
Also, the custType field is added by means of a join in the query. Because this field should be
excluded from the update, you create a field item with the following values:
FieldName = "custType"
OwnerName = "JoinedField"
IsKey = "false"
When the field items are defined, Flash Player can use them to automatically generate the
complete XML, which is used to update a table.
Note: The FieldInfo parameter makes use of a Flash feature called the Collection Editor. When you
select the FieldInfo parameter, you can use the Collection Editor dialog box to add new FieldInfo
items and set their
fieldName, ownerName, and isKey properties from one location.