Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to run Stored Procedure?
Message
 
 
To
05/05/2006 02:10:06
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:
01119562
Views:
14
>>>Would it not be feasible to simply rename your stored procedure, or your other procedure?
>>Yes, I plan to remove this function from the procedure file and leave in SP.
>>
>>However, my question still remains - how can I bypass the extra search? I know that my function is in SP and I want to be able to explicitly tell VFP to look there and in no other places.
>
>You cannot. This is a VFP bad design.
>The syntax dbcAliasName!SPName() is the natural syntax, but ....

Thanks. Also the Help is not clear enough... What would be the best way to name my procedure PROCEDURE or FUNCTION and the best way to call

=MyFunction(par,par) or DO myFunction with ... to make internal search quicker?

Thanks.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform