COMMIT in onPush
clembo
Member Posts: 122
I've a List Job form. In this form there is a button. When user push this button execute this code:
localJob.INIT;
localJob.Template := FALSE;
localJob."Contract Status" := localJob."Contract Status"::"Open";
localJob.INSERT(TRUE);
COMMIT;
CLEAR(VeichleContractCard);
VeichleContractCard.ImpostaFiltro;
VeichleContractCard.SETTABLEVIEW(localJob);
VeichleContractCard.SETRECORD(localJob);
VeichleContractCard.RUNMODAL;
First time that execute code it's work great creating new JOB.
Second time it's shows an error because try to create same Job number.
Why this? I've inserted COMMIT to write transaction. Series increment number correctly but my form don't know this.
How I can solve?
localJob.INIT;
localJob.Template := FALSE;
localJob."Contract Status" := localJob."Contract Status"::"Open";
localJob.INSERT(TRUE);
COMMIT;
CLEAR(VeichleContractCard);
VeichleContractCard.ImpostaFiltro;
VeichleContractCard.SETTABLEVIEW(localJob);
VeichleContractCard.SETRECORD(localJob);
VeichleContractCard.RUNMODAL;
First time that execute code it's work great creating new JOB.
Second time it's shows an error because try to create same Job number.
Why this? I've inserted COMMIT to write transaction. Series increment number correctly but my form don't know this.
How I can solve?
0
Comments
-
As you can see in the online help INIT doesn't reset the primary key fields. Try to use CLEAR instead."Money is likewise the greatest chance and the greatest scourge of mankind."0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K 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
- 328 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