Jump to content

Determine highest serial number


This topic is 4400 days old. Please don't post here. Open a new topic instead.

Recommended Posts

What is the easiest way to compute the highest serial number in a column, in FM10?

The serial numbers are of the form P-000002 - that is, fixed-width integer with alpha prefix (thus unusable by the max() function).

If sort / goto record is the only way, so be it - just thought there might be a better way.

Thanks,

Chap

Link to comment
Share on other sites

...thus unusable by the max() function).

Hi

what about using the Min ( ) function ?

Try this calculation:

"P-" & Right ( "000000" & Abs ( Min ( YourSerial ) ) ; 6 )

Note that this will work ONLY if your serial is always in the format: P-nnnnnn

Link to comment
Share on other sites

 Min ( YourSerial )

I don't think that's a valid expression (unless YourSerial is a repeating field).

My impression is that OP wants the highest serial number in a found set, and cannot use a summary field for this. We need to know if the prefix character is always a single "P".

Link to comment
Share on other sites

I don't think that's a valid expression (unless YourSerial is a repeating field).

My impression is that OP wants the highest serial number in a found set, and cannot use a summary field for this. We need to know if the prefix character is always a single "P".

YourSerial was an abbreviation for a self-related field, commonly used for the Summary functions, but you are right... it is better to specify:

"P-" & Right ( "000000" & Abs ( Min ( CartesianSelfJoin::YourSerial ) ) ; 6 )

He said that cannot use the Max( ) function, so I think that he needs the max from all the records.

Link to comment
Share on other sites

This topic is 4400 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.