HyperfileSQL multiple return values

HI,
Firebird respective PostgreSQL have support for multiple return values.
like return a,b,c

In HFSQL this is, afaik, not possible...
In general we are passing parameters by reference. like

// stored example procedure
Procedure whatever(LOCAL x, val1, val2 ) // valx passed by ref, x is copy.
val1 =2;val2 = "abc" //

Is it possible to get the new values of val1, val2 ?
In case that this is possible, I am curious how this works (technical) ?

TIA, Bjoern

Hi Bjoern

How about using just one parameter which is a delimited list?


Regards

Malc

Hi Bjoern,

it is possible to get the new values of Val1 and Val2 IF and only IF they are variables... You do not need anything else, as by default wlanguage pass parameters by address

so if you do

iVal1 is int=2
sVal2 is string="abc"

then call your procedure, change the value of the parameters in the proc, you'll get the new values in iVal1 and sVal2

Best regards