db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sylvain Leroux <sylv...@chicoree.fr>
Subject Re: IJ scripting (variables in IJ?)
Date Sat, 30 Jan 2010 19:48:42 GMT
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
> 
> 
> 


-- 
sylvain@chicoree.fr
http://www.chicoree.fr



Mime
View raw message