Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to run Stored Procedure?
Message
From
04/05/2006 20:41:31
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
Miscellaneous
Thread ID:
01119387
Message ID:
01119457
Views:
22
Would it not be feasible to simply rename your stored procedure, or your other procedure?

>Thanks a lot. Well, according to this
>Internal commands ( if the function is not prefixed with m.) and base classes, then
>
>User-defined class definitions cached in memory in the order they were loaded, so long as the class definitions are still along SET CLASSLIB or SET PROCEDURE, then
>
>If in VFP 8, a collection's default method, for example myCollection(), then
>
>MyArray(n) array memory variable in scope.
>
>Functions and class definitions in the current .PRG, then
>
>Class definitions along SET CLASSLIB, then
>
>Functions and class definitions along SET PROCEDURE, then
>
>Functions and class definitions in the stored procedures of the current SET DATABASE TO, then
>
>Functions and class definitions in the execution chain (call stack), then
>
>Functions named for files bound in the app/exe, then
>
>Functions named for files in the SET DEFAULT (local) directory, then
>
>Functions named for files out along SET PATH.
>
>COM classes in the OLE registry if SET OLEOBJECT is ON.
>
>
>
>the function in set('procedure') would be called before database procedure.
>
>My question is: is where a way to bypass this VFP internal search and tell the engine to use my SP?
>
>Thanks again for your help.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform