Can we convert xml into Recordset?

ajaybabuCh

Hi

Can we convert xml into ADORecordSet in Navision codeunit?

garak

Why not, it's possible.
You must knwo how the xml file is "build", you must know the nodes and the attributes.
Take a look inti XML Dom Management. Then u must know how to use ADO. For this search also the forum.

ajaybabuCh

hi garak

I have registered one dll to Navision, I am calling one of dll functions from Navision. That dll function query the database and return data set in an xml format.

Here is the sample xml format (Module is the table and ModuleID and Module Name are columns)

<NewDataSet>
<Module>
<ModuleID>1</ModuleID>
<ModuleName>General Ledger</ModuleName>
</Module>
<Module>
<ModuleID>2</ModuleID>
<ModuleName>Payables and Purchases</ModuleName>
</Module>
<Module>
<ModuleID>3</ModuleID>
<ModuleName>Jobs</ModuleName>
<Module>
<Module>
<ModuleID>4</ModuleID>
<ModuleName>Sales and Receivables</ModuleName>
<Module>
</NewDataSet>

Is it possible to create ADORecordSet by taking the above xml format as input.

can you give me some sample code for this

ajaybabuCh

any idea on this