× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Birgitta Hauser wrote:
I believe that should be:

If %Parms >= 3 and %Addr(Parm3) <> *NULL;
//3rd parameter is passed
EndIf;

No, OR is correct, because %PARMS is set to -1 if called from an SQL UDF.


You can't count on %PARMS being set to -1. For a procedure call, %PARMS requires that an operational descriptor be passed. When the operational descriptor is not passed, calculating %PARMS might get MCH3601 and %PARMS would return -1. But %PARMS might find some old garbage at the place where it would look for the operational descriptor, and in that case it would return whatever value it found, maybe -5 or 2 or 13 or whatever.

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

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

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.