× 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.


  1.  Home
  2. MIDRANGE-L
  3. March 2012

Re: Creating an SQL UDF on a procedure

No matter the feasibility of ensuring the additional invocation will be coded in a UNION. A data-related means would be near impossible to effect *properly* the desired final-call effect via a query, because there is almost no way to know in what order the function would get called :-( [though perhaps the last row generated in a recursive query]

Regards, Chuck

On 15-Mar-2012 08:04 , Alan Shore wrote:
But then we have to inform everyone who will use this function going
forward of this procedure. I am not saying it's not feasible, just
that eventually someone is not going to do that, and then we are back
to my original questions.

McGovern, Sean on Thursday, March 15, 2012 10:59 AM

Union with fixed -1 value ?

Alan Shore on 15 March 2012 14:58 wrote:

Nice idea but how do we send -1 down when using this function
within a view, or sql?



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-2025 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.