Min and Max

Hanen · 2009-09-02

Hello,

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.

matttrax · 2009-09-02

FINDFIRST and FINDLAST are the way to go.

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.

SBN · 2009-09-02

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.

Hanen · 2009-09-02

Thanks a lot, it works with

Cust.SETCURRENTKEY(Cust."Customer No.");

I forgot that detail :oops:
:thumbsup: =D>

DenSter · 2009-09-02

Yes the sort order is important

Alex_Chow · 2009-09-02

Customer No. is a code field.

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.

garak · 2009-09-03

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.

regards

Min and Max

Comments

Categories