Hello all
I wrote,
In short we want one prompt where we can select either a number from the LOV or a value that will select the highest number available!
I got some input from K.Unnikrishnan.Nair at my private mail. It was not exactly what I was looking for but it gave me an idea for a solution.
Below you find the solution for my problem! Beware: this condition doesn’t parse Ok, but it works fine (for me)!
TABLE.NUMBER = (SELECT MAX(TABLE.NUMBER) FROM TABLE) and (@VARIABLE(‘Give listnumber or 0 for highest listnumber’) = 0) OR (TABLE.NUMBER IN @Prompt(‘Give listnumber or 0 for highest listnumber’,‘N’,‘LISTS\Nummer’,multi,))
I used the 0 cause this value is never an occurence in the number column!
Greetings,
Robert Duindam
robert.duindam@nl.fortis.com
DISCLAIMER******** Deze e-mail is uitsluitend bestemd voor de geadresseerde(n). Verstrekking aan en gebruik door anderen is niet toegestaan. Fortis sluit iedere aansprakelijkheid uit die voortvloeit uit electronische verzending.
This e-mail is intended exclusively for the addressee(s), and may not be passed on to, or made available for use by any person other than the addressee(s).
Fortis rules out any and every liability resulting from any electronic transmission.
Listserv Archives (BOB member since 2002-06-25)