Export result of query to XML

[Former Member]

Hi.

Can anyone tell me if and how it's possible to export the results of a query to xml format?

We are currently using SAP B1 2005A. SQL server 2005.

Thanks and regards,

Runar Wigestrand.

[former_member187989 · Accepted solution]

hi,

Exectue query.

In Menu bar File ---> Export To --> Form to XML.

Jeyakanthan

[Former Member]

Dear Runar,

You can achieve this by using SDK.

In case you want to write the records of recordset as XML format, you can try the following.

oRecordSet.DoQuery(sql)

StrXML = oRecordSet.GetAsXML()

But if you want to write the results to XML object like Business Partner or document, use method SaveXML.

Regards,

Rakesh Pati

SAP Business One Forum Team.