Steve, To elaborate on Ken's response:
I typically use variables in the stored procedure that begin with 'sp' or some other convention that I don't use in normal code. Then, whenever I arrive at the value I want to return, I'll use a variable such as 'vreturn' to hold that value. Then: CLEAR VAR sp% RETURN .vreturn Finally, in the calling code, the statement just after the call can clear the variable vreturn, assuming, of course, that the variable you asked the call to populate was something else. Emmitt Dove Manager, DairyPak Business Systems Evergreen Packaging, Inc. [EMAIL PROTECTED] (203) 214-5683 m (203) 643-8022 o (203) 643-8086 f [EMAIL PROTECTED] -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Wills, Steve Sent: Friday, September 19, 2008 2:05 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Question About RETURN [vValue] in Stored Procedures I have a question about RETURN and RETURN .vMySPValue. At what point does control pass back to the caller of the Stored Procedure : > "RETURN .vMySPValue" > "RETURN", assuming that a RETURN can and does follow a "RETURN .vMySPValue" > After last statement of Stored Procedure, if there is no form of "RETURN", although I think that a well-written SP should have some sort of RETURN ... I ask because I want to know where to CLEAR my VARIABLES that are local_to||used_by the SP. Thanks, Steve in Memphis J. Stephen Wills Program Manager, Research Informatics Office of the Vice Chancellor for Research University of Tennessee Health Science Center 62 S. Dunlap, Suite 400 Memphis, TN 38163 Office: 901-448-2389 FAX : 901-448-7133
