Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Set procedure behavior
Message
From
01/03/2022 12:15:14
 
 
To
01/03/2022 09:29:30
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01683692
Message ID:
01683711
Views:
40
>>Drew Speedie was famous for saying "Tricks are for Grids".
>>Are tricks also for "Set Procedure To"?
>>This is anecdotal admittedly, but twice in the last year the mere act of setting procedure to MyProgram Additive has "shot me in the toe" (so to speak).
>>In one case merely setting procedure caused an immediate corruption of a table. This was repeatable.
>
>I suggest to NOT use functions from procedure files in Index's Key and FOR expressions. Even if the procedure file is already open when the table is open, reopening the procedure may confuse VFP and corruptions may occur. Such function calls should be either standalone program files or as a Stored Procedure so they are visible always.
>
>>In another case merely setting procedure to MyOtherProgram additive caused a running form to close.
>>i can't possible count how many times i have set procedure to xyz program since 1994.
>>So what is it i don't know about "Set Procedure"? Much i am sure.
>>
>>Dumb as a post here

Thanks Greg,

It's not germane in this case but good advice nonetheless and i will keep in mind going forward.
I do use function calls within queries occasionally.
Barry Taft
i am only worried in the short term. once there is a problem, the solution usually presents itself.
Previous
Reply
Map
View

Click here to load this message in the networking platform