Thom
What you return also depends on what value the
stored procedure produces!! If the end result is just to update / insert /
delete rows, print a report etc., then I think either RETURN 0 or RETURN '0'
should work. But if its goal is to return a VALUE, then the variable
holding that value belongs there:
RETURN .varname
----- Original Message -----
Sent: Monday, February 07, 2005 5:17 PM
Subject: [RBG7-L] - Re: FW: [RBG7-L] - Oterro & Stored
Procedures
I used
the RBG7 Stored Procedure editor to copy my text in there. I didn't PUT the
procedure there. So in that case, should I RETURN 0 or RETURN '0'
?
I
guess I should just try both and see what happens.
Thanx
Emmitt
Thom
Cimicato
Thom,
Stored procedures must have a
return value even if only a dummy. So you must use the format RETURN x
where x is the value, of the type specified in the PUT command.
So, if
you:
put
blatz.prc as blatz vblatz text return integer
Then you
must:
return
0
or some other integer value.
If you on the other
hand:
put
blatz.prc as blatz vblatz text return text
then you
must:
return
'0'
or some other text value.
"urn:schemas-microsoft-com:office:office" xmlns:w =
"urn:schemas-microsoft-com:office:word">
I
have a WiTango app that inserts a record. There is a trigger on that insert
that fires a stored procedure.
Oterro/WiTango is
returning an error of some sort. The stored procedure works perfectly
except that there is an error on the RETURN (I think).
What is the
proper way to RETURN from a stored procedure?
RETURN or RETURN 0 or what?
Thomas
Cimicato
Emmitt Dove
Manager, DairyPak Business Systems
Blue Ridge
Paper Products, Inc.
40 Lindeman Drive
Trumbull, CT 06611
(203)
673-2231
[EMAIL PROTECTED]
[EMAIL PROTECTED]
|
