[RBG7-L] - Re: FW: [RBG7-L] - Oterro & Stored Procedures

[David M. Blocker]

Tom   At the end of the procedure itself, RETURN normally is enough. But in CREATING the stored procedure with a PUT command, you want to end with   RETURN datatype 'comment'   e.g.   RETURN DATE 'Date of next step'   or   RETURN CURRENCY 'Calculate and update a value'   David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: Thomas Cimicato To: RBG7-L Mailing List Sent: Sunday, February 06, 2005 9:57 PM Subject: [RBG7-L] - FW: [RBG7-L] - Oterro & Stored Procedures 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