Create new Project by ODBC (codeunit)/ simulate F3 (new)

Trushy
Member Posts: 2
Hi everyone
We are searching for a solution to simulate user-request "F3" (new) by ODBC (in fact, it is JDBC-ODBC).
At the moment, we are able to read the data we need and to update an existing project by using ODBC, but we don't know how to create a new project.
Normally, NAV-client creates a new project by clicking on Button "new" in toolbar or pressing "f3"- both actions create a new Project, based by the last number of the existing projects.
Example: Last created Project-reference is "P14400" and a user is pressing F3. This will generates automatically a new Project with the reference "P14410" (automatically incremented by 10).
Based by this, next user will get "P14420" as new project+number.
Now: how can we execute this code by external application (like JAVA or PHP or....)? Is it even possible to use this Navision code by ODBC?
Thanks for strong support in advance and best regards
Trushy
We are searching for a solution to simulate user-request "F3" (new) by ODBC (in fact, it is JDBC-ODBC).
At the moment, we are able to read the data we need and to update an existing project by using ODBC, but we don't know how to create a new project.
Normally, NAV-client creates a new project by clicking on Button "new" in toolbar or pressing "f3"- both actions create a new Project, based by the last number of the existing projects.
Example: Last created Project-reference is "P14400" and a user is pressing F3. This will generates automatically a new Project with the reference "P14410" (automatically incremented by 10).
Based by this, next user will get "P14420" as new project+number.
Now: how can we execute this code by external application (like JAVA or PHP or....)? Is it even possible to use this Navision code by ODBC?
Thanks for strong support in advance and best regards
Trushy
0
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
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions