Bill's explanation is more complete than mine. Stored procedures can
return values; triggers are stored procedures. Even if the trigger is
not expected to return a value, the stored procedure is often expected
to return a value.
Albert
Bill Downall wrote:
It's not so much that triggers return values, but stored procedures
can. In the help files, read "using stored procedures."
For example, you can call a stored procedure to set a variable to the
value after the last "RETURN value" statement.
Dennis, you were still the developer of R:Style back in 6.5 when
"RETURN value" became a valid syntax. I can't remember what change you
had to make to R:Style then, but you had to do something to
distinguish it from the RETURN at the end of a command file.
Bill
On Thu, Jan 14, 2010 at 12:32 PM, James Bentley
<[email protected] <mailto:[email protected]>> wrote:
Albert,
I am curious where you found this tidbit of info in the documentation.
I was under the impression that Triggers were not supposed to
RETURN values since They are automatically called and have no way
for the user to interact with them after they complete execution.
Jim Bentley
American Celiac Society
[email protected] <mailto:[email protected]>
tel: 1-504-737-3293
----- Original Message ----
From: Albert Berry <[email protected]
<mailto:[email protected]>>
To: RBASE-L Mailing List <[email protected]
<mailto:[email protected]>>
Sent: Thu, January 14, 2010 10:34:19 AM
Subject: [RBASE-L] - Re: date tracking question
Hi, all. The system expects the trigger to return a value to a calling
procedure. Zero is as good as anything.
Albert
[email protected] <mailto:[email protected]> wrote:
> Dennis: I actually have no clue what the RETURN 0 is for.
> This code is in my notes document, I've never had a reason to
> use it yet, so this was just a copy and paste of someone else's
> suggestion. I don't think I've ever used RETURN 0.
>
> Karen
>
>
>> Thanks,
>>
>> I’ve got a demo running nicely, thanks to you and Emmitt.
>>
>> What is the 0 after your returns?
>>
>>
>>
>>
>> *From:* [email protected] <mailto:[email protected]>
[mailto:[email protected] <mailto:[email protected]>] *On Behalf Of
>> *[email protected] <mailto:[email protected]>
>> *Sent:* Wednesday, January 13, 2010 4:22 PM
>> *To:* RBASE-L Mailing List
>> *Subject:* [RBASE-L] - Re: date tracking question
>>
>>
>>
>>
>> I think a variable is the ONLY way. Here's example code:
>>
>> SET VAR trigger_executed INTEGER
>> IF trigger_executed = 1 THEN
>> CLEAR VAR trigger_executed
>> RETURN 0
>> ENDIF
>> ... {body of trigger}
>> SET VAR trigger_executed INTEGER = 1
>> RETURN 0
>>
>>
>>
>
