I want to get the min Customer No and max customer No from my table, how can I do that, I used the findfirst and findlast but it didn't give me the right results
Thanks for your help, I need an answer as soon as possible.
Perhaps you could provide us with some more details. Tell us what output you were expecting and what output you got based on some sample data. Your code might also be helpful.
Hello,
I think that records in the table customer are not sorted by No,so you must put this instruction before FINDFIRST or FIND('-') and FINDLAST or FIND('+');
SETCURRENTKEY(No);
If you don't have No like key you must create it before.
don't foreget, like Alex said, that these field is a code field.
so, if u have a numering only with number without leaving zeros, like 1,2,25,10 and not 000001,000002,0000010,000025 .... the sql server will not give you the first and last numer ;-)
exampel:
1
10
11
2
What do you think, what findfirst and findlast get ..... right the 1 and the 2 but this is not what you need. So, before you run this statement, u must know how you're customer numbers are "defined" (numeric without zero, alpanumeric or only alpha)
if u use the native server, then the order is 1,2,10,11.
Comments
Perhaps you could provide us with some more details. Tell us what output you were expecting and what output you got based on some sample data. Your code might also be helpful.
My Blog - nav.education
I think that records in the table customer are not sorted by No,so you must put this instruction before FINDFIRST or FIND('-') and FINDLAST or FIND('+');
SETCURRENTKEY(No);
If you don't have No like key you must create it before.
:thumbsup: =D>
Hanen TALBI
RIS Plus, LLC
MVP - Business Apps
So if you sort it by the customer number, it will be
1
10
9
In this case, the FINDLAST will return 9 and FINDFIRST will return 1 when infact the max should be 10.
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book
so, if u have a numering only with number without leaving zeros, like 1,2,25,10 and not 000001,000002,0000010,000025 .... the sql server will not give you the first and last numer ;-)
exampel:
1
10
11
2
What do you think, what findfirst and findlast get ..... right the 1 and the 2 but this is not what you need. So, before you run this statement, u must know how you're customer numbers are "defined" (numeric without zero, alpanumeric or only alpha)
if u use the native server, then the order is 1,2,10,11.
regards