Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to run Stored Procedure?
Message
From
05/05/2006 13:59:35
 
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:
01119697
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

Name is a it is a subjective choice.
After about ten different ways,
I have understood that a best name doesn't exist,
but many worse names certainly exist.

> and the best way to call
>
>=MyFunction(par,par) or DO myFunction with ... to make internal search quicker?
>
>Thanks.

The first is better.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform