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]>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] > tel: 1-504-737-3293 > > > > ----- Original Message ---- > From: Albert Berry <[email protected]> > To: RBASE-L Mailing List <[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] 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]] *On Behalf Of > >> *[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 > >> > >> > >> > > > > > > > >
