Missing #s Re:

This might not be what you are looking for.
I have some simple RPG programs that I wrote that my users run occasionally.

What item #s are open, available to be assigned, inside some range?
Something similar for shipping tracking #s.

The program reads 2 consecutive #s, does the math ... tells users how many #s are open in there. When #s are contiguous, all that prints are the #s before & after gaps, to illuminate what's available.

For example ... 916543 is used, so is 916554 but nothing in between
so my program explicilty shows
916543 is used
916544 to 916553 available = 10
916554 is used

An engineer might need 25 new #s to assign, looks down the list to find a cluster close to that.

At very bottom of report is a figure to show how close we are to running out of numbers again.

Hi all,

Is there a way to select the numbers missing from a list of numbers ?

I mean, if I have a table with keys 1, 2, 3, 5, 6, 9,

can I find the numbers missing between 1 and 10? ie, return 4, 7, 8, 10.

I could create a table with 1 zone filled with the numbers 1 to 10 and then do an outer join. But I need this in a program. I need to find the smallest missing number in a given range of numbers.

Thanks.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.