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
- 269 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
Ordering fail
Alkro
Member Posts: 115
Why this code is wrong?
I want, filter with dates input by user, and then order by "Prod. Order No.".
Watching Table 32, there is 20 records that have to appear, but only can show 16... Why?
If I delete lines marked //***, records are correct. How can i change the Key to Order by Prod. Order No.??
OutMat.RESET;
OutMat.SETCURRENTKEY("Posting Date","Item No.","Entry Type");
OutMat.SETRANGE(OutMat."Posting Date",StartD,EndD);
OutMat.SETRANGE(OutMat."Item No.",'ARG01','ARG99');
OutMat.SETRANGE(OutMat."Entry Type",OutMat."Entry Type"::Output);
IF OutMat.FIND('-') THEN BEGIN
OutMat.SETCURRENTKEY("Prod. Order No.","Posting Date","Item No.","Entry Type"); //***
OutMat.ASCENDING(TRUE); //***
I want, filter with dates input by user, and then order by "Prod. Order No.".
Watching Table 32, there is 20 records that have to appear, but only can show 16... Why?
If I delete lines marked //***, records are correct. How can i change the Key to Order by Prod. Order No.??
0
Answers
You are setting the key after you have gotten the first record from the previous sorting so the pointer may be at the wrong record when you set the 2nd key.
best bet would be to set the ranges and then set the 2nd currentkey before the FINDFIRST (FINDSET)
Albert
Thank you!