Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Calling stored procedures
Message
From
03/02/1999 12:46:56
 
 
To
03/02/1999 12:36:05
Daniel Christensen
University of Wisconsin River Falls
River Falls, Wisconsin, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00183511
Message ID:
00183520
Views:
18
Try this:
 SET DATABASE TO (the database with the stored procedure)
DO next_id
The trick is that the database with the stored procedure must be the current dbc. Just because a DBC is open doesn't mean it's current.

Note that when you do this from a field-level default value you don't need the SET DATABASE TO ... part.

>I am having trouble calling a stored procedure from one of my form methods. The procedure that I am trying to call returns the next available unique id for a given table. As I call the procedure I get a runtime error stating that it cannot find "next_id.prg". I have checked to make sure that the database container is actually open at the time of the call. Can anyone help me out here?
>
Previous
Reply
Map
View

Click here to load this message in the networking platform