602SQL Documentation Index  

XML Data Bound to Application Data

Values that repeat in the XML file usually correspond with certain columns in a database. Values that occur only once do not necessarily need to be bound to the database. It is sufficient to insert these values into variables during XML import and use them directly in an application, or prepare these variables during export and write them to the XML file.

The XML format specification often requires that a certain value appear in certain attributes (e.g. mustUnderstand="1" often appears in SOAP). These values do not need to be written to the database (in fact it makes no sense to store them). It is better to specify a particular value for export in the DAD and check the occurrence of this value during import.

The XML extension allows you to bind an item from an XML file:

You must specify one of these methods for each attribute value or text in an element when designing the DAD (the XML text properties and XML attribute properties dialogs have three checkboxes, one must be checked).

Omit attributes that should be ignored during import in the DAD.

Data Format

The format of input or output data in the XML text is described on the Elementary data format page. The default format is sufficient for most types, but sometimes it may be necessary to modify the DAD to accept different notations of date and time. If the data format cannot be analyzed using this method, a general translation using an SQL function (the Translation button in the XML text properties and XML attribute properties dialogs) must be used.

List of topics: