Hi Thomas,
Maybe you could use a temporary table to "emulate" variables in IJ?
In that case you will need to rewrite your procedures as functions.
Regards,
Sylvain
Thomas a écrit :
Hi,
I would like to execute a series of statements in IJ where the value returned by
the function call executed in one statement is passed as a parameter to the next
statement calling another procedure.
Example:
CALL "SF_addClient"('lastname', 'firstname')
==> this function creates a new client record returning the client ID
automatically generated which was given to the client)
CALL "SF_addClientAddresses"('clientid', ....)
==> this would add some client info into a different table where clientid is a
field in this table.
With
values CALL "SF_addClient"()
I can see the return value, but how can I store this in a variable /use the
return value in further processing?
Is this possible to achieve in IJ?
Thanks
--
[email protected]
http://www.chicoree.fr
