Can we convert xml into Recordset?

ajaybabuCh
ajaybabuCh Member Posts: 208
edited 2009-01-13 in NAV/Navision Classic Client
Hi

Can we convert xml into ADORecordSet in Navision codeunit?
Ajay

Comments

  • garak
    garak Member Posts: 3,263
    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.
    Do you make it right, it works too!
  • ajaybabuCh
    ajaybabuCh Member Posts: 208
    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
    Ajay
  • ajaybabuCh
    ajaybabuCh Member Posts: 208
    any idea on this
    Ajay

Categories