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
- 264 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
Page Web Services - AutoSplitKey problem
derrick
Member Posts: 86
Hi buddies,
I created a Card type Page Web Services and used it in the .Net web application to insert new records with Create/CreateMultiple.
I had set the Page properties:
AutoSplitKey = Yes,
DelayedInsert = Yes
The table binding by the Page has only a key: "Name, LineNo".
The problem was the "LineNo" kept on increasing every time I inserted new records even the "Name" was different. For instance,
Record 1: "Jessica, 10000"
Record 2: "Peter, 20000" => #-o I am looking for 10000 for this record's LineNo.
Any suggestion what should I do :?: Thx.
I created a Card type Page Web Services and used it in the .Net web application to insert new records with Create/CreateMultiple.
I had set the Page properties:
AutoSplitKey = Yes,
DelayedInsert = Yes
The table binding by the Page has only a key: "Name, LineNo".
The problem was the "LineNo" kept on increasing every time I inserted new records even the "Name" was different. For instance,
Record 1: "Jessica, 10000"
Record 2: "Peter, 20000" => #-o I am looking for 10000 for this record's LineNo.
Any suggestion what should I do :?: Thx.
0
Answers
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
Instead of web services, I had also tried it by inserting a new record from the RTC, it resulted the same outcome.
Anyhow, if I make a form and run it in the classic client, record was inserted nicely into the table.
Any ideas?
Probably you did solve this already ages ago. But for those hitting this post: I ran into a same kind of issue (not using web services, but just running a document page on RTC) where lines cerated on subpage having AutoSplitKey on. And I found out it all was due to the PageType property. It was set to List, but has to be ListPart.
Never stop learning
Van Vugt's dynamiXs
Dutch Dynamics Community
The "Line No." of the first record is not 10000, but the next "Line No." of existing records in the table.
Also the "Line No." of the second record is not increased with 10000.
Anyone else who has this experience?