RDBMSResolver parameters

You can set the following authoring parameters for each RDBMSResolver instance by using the Parameters tab of the Component inspector:

TableName is a string representing the name (in the XML) of the database table to be updated. This string should match the name of the RDBMSResolver.fieldInfo item to be updated. If there are no updates to this field, this parameter should be blank, which is the default value.

UpdateMode is an enumerator that determines the way key fields are identified when the XML update packet is generated. Possible values are as follows:

umUsingAll Uses the old values of all of the modified fields to identify the record to be updated. This is the safest value to use for updating, because it guarantees that another user has not modified the record since you retrieved it. However, this approach is time consuming and generates a larger update packet.
umUsingModified Uses the old values of all of the fields modified to identify the record to be updated. This value guarantees that another user has not modified the same fields in the record since you retrieved it.
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 component's 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.

View comments on LiveDocs