RE: SQL Functions

["Joe Pluta" <joepluta@xxxxxxxxxxxxxxxxx>]

Can parameters be updated?  If so, I would suggest that if you need
multiple return values from a single record at a distinct point in time,
then define the function with all of the required values as updatable
parameters.

Joe

> From: Dave Schnee
> 
> One possibility would be to add a second parameter to each function
call
> to be used as a switch to indicate whether or not to (re)fetch the
data
> record.  Turn this switch *ON only in the first function to be called.
> Now, the question arises "how do you know in what sequence these are
used"
> in a composite select statement such as that shown in David's posting?
> Perhaps the best answer to this is that the second parameter is
updated by
> each function so any one of them will fetch the data and turn off the
> switch.  You then just have to turn the switch *ON before using the
> composite select statement.