Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K 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
- 267 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 SQL Performance
- 33 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
Options
Line No. does not Auto-increment
jhanvincent14
Member Posts: 214
I'm a newbie developer here 
I have this custom table that I created and it has a Line No. Column as my primary key and also for identifier purposes.
I have this custom code that I created its very simple, yet I have this kind of problem encountered. hope you guys can help me with this one. (See attached Images) by the way. "Line No." located at Test BF table
I have this custom table that I created and it has a Line No. Column as my primary key and also for identifier purposes.I have this custom code that I created its very simple, yet I have this kind of problem encountered. hope you guys can help me with this one. (See attached Images) by the way. "Line No." located at Test BF table
0
Best Answers
-
Options
Peter+is1
Member Posts: 174
Hi,
You need to init the record each time you want to create a new record. (so inside the loop)
(also would suggest to reserve the name 'Line No.' for real Nav like Line No.'s, but that is off topic)
Good luck.\\The truth exists in seven versions.5 -
Options
RockWithNAV
Member Posts: 1,139
Hey Jhan,
Write recTestBF.INIT; Just after the Repeat Statement.
It will work.
Thanks
Blog - rockwithnav.wordpress.com/
Twitter - https://twitter.com/RockwithNav
Facebook - https://facebook.com/rockwithnav/5 -
Options
vaprog
Member Posts: 1,118
Hi,
you actually need to explicitly set "Line No." to 0 each iteration of the loop. You can do this using CLEAR or using assignment.
INSERT sets the "Line No." field to the value autoincrement generated.
INIT does not clear it again, because it does not initialize primary key fields.
If "Line No." does have any value other than 0 on calling INSERT, autoincrement is not used but the value given is used instead (and autoincrement uses this as it's new value to increment from).6
Answers
You need to init the record each time you want to create a new record. (so inside the loop)
(also would suggest to reserve the name 'Line No.' for real Nav like Line No.'s, but that is off topic)
Good luck.
Write recTestBF.INIT; Just after the Repeat Statement.
It will work.
Blog - rockwithnav.wordpress.com/
Twitter - https://twitter.com/RockwithNav
Facebook - https://facebook.com/rockwithnav/
you actually need to explicitly set "Line No." to 0 each iteration of the loop. You can do this using CLEAR or using assignment.
INSERT sets the "Line No." field to the value autoincrement generated.
INIT does not clear it again, because it does not initialize primary key fields.
If "Line No." does have any value other than 0 on calling INSERT, autoincrement is not used but the value given is used instead (and autoincrement uses this as it's new value to increment from).