Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Calling Stored Procedures
Message
From
25/09/1997 14:27:36
 
 
To
10/09/1997 15:12:26
Michael Humphreys
Northern Airborne Technology Ltd.
Kelowna, British Columbia, Canada
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00049387
Message ID:
00051634
Views:
29
Hi Mike.

>I don't seem to be able to call a stored procedure from a method in a form. I use the SP to generate an index key and also need to call it from various methods/programs etc.

Your form is probably opening the tables through its DataEnvironment. When the tables are opened, the database they belong to isn't automatically selected, so the stored procedures aren't available. You need to SET DATABASE TO in the Init of the form. For example, I do something like this:

if set('DATABASE') <> cursorgetprop('Database',
)
set database to (cursorgetprop('Database',
))
endif

Doug
Previous
Reply
Map
View

Click here to load this message in the networking platform