Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.6K 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
- 296 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
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
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