Victor,
Have you PUT the stored procedure? How do you call it?
You have to PUT the stored procedure to truly make it such, then:
SET VAR vx = (CALL(procname))
to invoke it.
Your error message suggests that you have a RETURN 0 (or other argument to RETURN), which is required by a SP, but which is not truly in a procedure stored in the database.
What are the limitations of stored procedures. I have a button on the form
that i need to make it edit 2 different forms. This is very easy using the property command to switch between eep's. I had the idea to switch between stored procedures and keep the code inside the database and maybe learn how to use stored procedures. When I run the form and push the button that is running the Procedure i get a "Syntax is incorrect for return 2045" but if trace it from the R> no error.
The code for the procedure is very simple and really does not need to return any value.
EDIT USING SomeFormName Do some other stuff when exiting the form
Victor Timmons Tiz's Door Sales, Inc 425-258-2391
Emmitt Dove Manager, DairyPak Business Systems Blue Ridge Paper Products, Inc. 40 Lindeman Drive Trumbull, CT 06611 (203) 673-2231 [EMAIL PROTECTED] [EMAIL PROTECTED]
