Export (0) Print
Expand All
Expand Minimize

Format/Evaluate Property

Microsoft Dynamics Nav 2009

Sets the data that is being imported or exported as XML data types or as the standard C/SIDE data types.

XMLports

C/SIDE Format/Evaluate (default)

XML Format/Evaluate

Importing

If the XML document that you want to import contains data that corresponds to the standard C/SIDE data types, use C/SIDE Format/Evaluate (default value). The data is then evaluated before being inserted into the database.

If the XML document that you want to import contains data that uses the standard XML data types, use the XML Format/Evaluate setting. This ensures that the data is evaluated and converted to the C/SIDE data types before being inserted into the database.

If the data that you want to import does not follow either the Standard C/SIDE formats or the XML formats, import the data into a temporary table in text format. You can then use C/AL code to convert the data before inserting it into the database.

Exporting

If you want to export data that uses the standard C/SIDE data types to an XML document and use these data types in the XML document, use C/SIDE Format/Evaluate (default value). The data from the database is then formatted according to the standard rules for C/SIDE data types.

If you want to export data in the standard XML formats to an XML document, use the XML Format/Evaluate setting. This ensures that the data you export from the database is formatted and exported in the standard XML formats.

The following XML Data types require evaluation.

XML Data Type Microsoft Dynamics NAV Data Type

Decimal

Float

Double

Decimal

Boolean

Boolean

Datetime

DateTime

Time

Time

Date

Date

Integer

Integer

Duration

Duration

This is an XMLport property and therefore applies to all the data that is being streamed. It cannot be applied only to specific fields.

For more information about formatting C/SIDE data types, see Format Property. For more information about evaluating variables, see EVALUATE Function. For more information about using temporary tables, see Temporary (XMLports) Property.

Community Additions

ADD
Show:
© 2014 Microsoft