Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K 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
- 317 Dynamics CRM
- 110 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
Filling the AutoSplitKey when inserting records through Code
harm.poelen
Member Posts: 36
Hi There,
I'm trying to insert records in the Navision Item Journal through code. All works well except that the Line No. Field is a AutoSplitKey field that is handled by the Form... and I am not using the Form.
I am about to write some code in the OnInsert trigger of the Item Journal Line table too lookup the last Line No. in the table and then add 100000... but I can not believe that that is the way to do this... or is it?
Harm
PS: HAPPY NEW YEAR TO ANYONE READING THIS MESSAGE !
I'm trying to insert records in the Navision Item Journal through code. All works well except that the Line No. Field is a AutoSplitKey field that is handled by the Form... and I am not using the Form.
I am about to write some code in the OnInsert trigger of the Item Journal Line table too lookup the last Line No. in the table and then add 100000... but I can not believe that that is the way to do this... or is it?
Harm
PS: HAPPY NEW YEAR TO ANYONE READING THIS MESSAGE !
CANE Microsoft Solutions BV
Prins Hendrikplein 14
2518 JC DEN HAAG
The Netherlands
http://www.cane.nl
Prins Hendrikplein 14
2518 JC DEN HAAG
The Netherlands
http://www.cane.nl
0
Comments
Afraid the answer is yes #-o.
I have never found any other way to do it but then I do not confess to know all there is to know about C/AL coding.
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
Maybe the OnInsert isn't the best place......
If you fill the table from only one point in Navision it's maybe better to fill the line no. from there.
If this isn't possible... Then you have to do it like you are doing it.
If it was hard to write, it should be hard to understand."
Take a look on Form 5198 Attendee Wizard Subform.
They implemented AutoSplitKey in C/AL there
Have fun!
Dmitry