Yes...this does the trick. 'Simple comme bonjour' as we say in Belgium...if you know how to do it...
Thank you very much, Karen ! Luc From: [email protected] Sent: Friday, June 11, 2010 12:29 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: setting a form variable with a stored procedure Luc: Just locate a Variable Label field on your form and assign it to "vpricetopay". After calling your stored procedure, do a "recalc var" to force the field to reevaluate on your form. Karen 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
