Design your stored procedure to return a result and assign the result
directly to the variable Like:
set var vTheVarToSet SomeDataType = (Call StoredProcedureName(Arg1, Arg2))
If the Form Field you want to set is not a variable field, then use the
Property command to set the field value to the variable returned by the
stored procedure.
----- Original Message -----
From: "Luc Delcoigne" <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Thursday, June 10, 2010 5:38 PM
Subject: [RBASE-L] - setting a form variable with a stored procedure
Hi,
On a form I have multipele currency fields.
Via a stored procedure I calculate the sum of certain fields (which varies)
and want to display the result of my stored procedure in a variable (or
other?) field on the form.
In access you can set the source/value property of a variable to "
=Procedure()".
In rbase I have a stored procedure that calculates the variable
"vpricetopay".
How can I set a variable to display this result dynamically on my form
without saving the value to a table ?
Tx
Luc Delcoigne
