This solution is not so evident for me.
Karen's solution works fine, but I'd like to have some more info on your
solution for the future.
Can you give me an example in extenso ?
Thank you very much, Mike.
Luc Delcoigne
--------------------------------------------------
From: "Mike Byerley" <[email protected]>
Sent: Friday, June 11, 2010 12:32 AM
To: "RBASE-L Mailing List" <[email protected]>
Subject: [RBASE-L] - Re: setting a form variable with a stored procedure
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
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================
