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