>I have a PUBLIC variable in my .app, and I would like to change its value from a Stored Procedure in the .DBC. Is this possible ? I couldn't get it to work.
>I am actually generating an error message during a UDF() that runs as
>a DELETE trigger. I would like to pass this error message back to my error handler.
>
>Any help is greatly appreciated
I do this all the time, for error handling purposes. I suspect you are getting lost somewhere in the implementation. Epxeriment by simplifying: Create a simple stored proc with one line: x = 1.
Call the stored proc from a command line, and check the value of x. Error. Now declare x public and call the proc, you get the value. You must be doing something else to release the variable.
Erik Moore
Clientelligence