Hi Everyone,

In table, query, view we have a system method as xml () which is used to display field value in Xml.  The structure of table/query is created as Xml. This method gives you the feasibility of populating the fields directly in xML without actually using the xML Classes available in AX.

Please find the following examples below:

Using Table:

static void TableFieldsAsxML(Args _args)
{
    #define.CustAccountNum('4000')
    #AOT
    #define.xmlFileName('.xml')

    CustTable   custTable;
    XmlDocument xmlDocument;
    str         _xml;
    ;

    xmlDocument = new XmlDocument();

    select firstonly custTable
        where custTable.AccountNum == #CustAccountNum;

    _xml = custTable.xml(1);
    xmlDocument.loadXml(_xml);
    xmlDocument.save(WinApi::getTempPath() +
                                     #AOTDelimiter +
                                     strins(strrem(xmlDocument.name(), '#'), #xmlFileName, strlen(xmlDocument.name()) + 1));
}

Please Note:  All this code snippets are a result of some development that came up from time to time. Please feel free to use them for your own use with discretion.

In AX2009 I tried manually creating DB and pointing Dynamics server to the created DB. When trying to start the AX services I ended up facing following errors.