Navision and external DB

FrancoFesti
FrancoFesti Member Posts: 5
edited 2004-03-24 in Navision Attain
Please excuse me for my stupid question...
i'm just a young italian programmer who is walking the long road towards Programmers Paradise :wink:

What i have to do to comunicate with an external Database ? I need to
* Read Data from External DB to Navision (3.70)
* Update data from Navision to External DB

Are there any routines dedicated to these tasks ? In the past i always used to communicate with ASCII files + a third program that red/wrote the External Program (Access DB, for example). But i now i need to find another way.

Could someone give me just an advice or, better, an example ?

Tanx a lot (Grazie Mille).

Franco.

Comments

  • Savatage
    Savatage Member Posts: 7,142
    Do you have a copy of the Applications Designer Guide that comes with the CD? If you want to get started programing this is where I would begin.
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org
  • FrancoFesti
    FrancoFesti Member Posts: 5
    tank you lad. very smart. very kind.
  • wonmo
    wonmo Member Posts: 139
    If you have the ocx granule then you could use either ADO or the C/ODBC driver.
  • FrancoFesti
    FrancoFesti Member Posts: 5
    :)
    tank you wonmo. But, i need to know hot to write it down in the C/AL.
    Example. If i want to read the table EXAMPLE in TEST.MDB database, what kind of globals i have to define ? and what kind of instructions i need to use ? and...does this job work with a normal ODBC driver (the driver that comes with Attain CD...) or i need particular settings ?

    Tanx again for your interest.

    P.S.
    Please don't answer with "...try to read the Applications Designers Guide..."
  • wonmo
    wonmo Member Posts: 139
    How are you approaching this task?

    Are you planning on creating some sort of external program or are you planning on doing all your coding in Navision? If you are going to use an external program (VB, Delphi, etc.) then the easiest way would be to use the C/ODBC driver and treat the Navision database as you would any relational database (ie. set up connections, query, etc.). If you are planning on doing all your coding in Navision then you won't need the C/ODBC driver. What you would do in this instance would be to create some automation variables of type ADO, class Connection, Command, Parameter and whatever other classes that you might need for your particular task. Are you familiar with using ADO in other programming languages?
  • Christian_Buehl
    Christian_Buehl Member Posts: 145
    In the Tips and Tricks Forum you can find an ADO Example.
    Right now its working with other DB's like MySQL ....
  • FrancoFesti
    FrancoFesti Member Posts: 5
    Then i'll check the trips and tricks forum guys.

    Thanx a lot Chris and wonmo!!!

Categories