|
-----Message d'origine-----
De : rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] De la part de Rory Hewitt
All I want now is to have a parameter to the SELECT
statement, which can be used in conjunction with each of the
WHEN statements to equate to a boolean true or false:
SELECT Customer.Type;
WHEN 'A';
...
WHEN 'B' or 'C' or 'D';
...
WHEN 'E' or 'F';
...
OTHER;
...
ENDSL;
which is much nicer (IMHO) than:
SELECT;
WHEN Customer.Type = 'A';
...
WHEN Customer.Type = 'B' or
Customer.Type = 'C' or
Customer.type = 'D';
...
WHEN Customer.Type = 'E' or
Customer.Type = 'F';
...
OTHER;
...
ENDSL;
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.