Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
.DBCs vs. Variables
Message
From
24/08/1999 16:31:13
 
 
To
24/08/1999 15:53:14
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00257275
Message ID:
00257294
Views:
16
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform