I want to set the value of an indicator to *on if I find at least one
record matching my search criteria and *off otherwise.

What's the best way?

eg :

indicator = *off;

exec sql
Select '1' into : indicator
from mytable

where ....err.. what goes here? what if there are many rows returned?


This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2020 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].