Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 310 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Navision and external DB
FrancoFesti
Member Posts: 5
Please excuse me for my stupid question...
i'm just a young italian programmer who is walking the long road towards Programmers Paradise
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.
i'm just a young italian programmer who is walking the long road towards Programmers Paradise
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.
0
Comments
http://www.BiloBeauty.com
http://www.autismspeaks.org
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..."
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?
Right now its working with other DB's like MySQL ....
Thanx a lot Chris and wonmo!!!