Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Moving from 7 to 9
Message
From
12/09/2006 06:01:26
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01152911
Message ID:
01152959
Views:
24
>>>...
>>>>
>>>>lnTablevalidate = set('tablevalidate')
>>>>lcSafety=set('safety')
>>>>set safety off
>>>>set tablevalidate to 0
>>>>Use yourtable exclusive
>>>>copy to temp
>>>>zap
>>>>append from temp
>>>>set tablevalidate to lnTablevalidate
>>>>if lcSafety='ON'
>>>>  set safety on
>>>>endif
>>>
>>>Just curious, Tore:
>>>
>>>You store the current set("safe") as I do:
>>>
>>>lcSafety=set('safety')
>>>
>>>so why not at the end:
>>>
>>>Set Safety &lcSafety
>>>
>>>rather than
>>>
>>>if lcSafety='ON'
>>>  set safety on
>>>endif
>>>
>>>
>>>in order to restore the prog's prev. setting? I guess it does just the same though.
>>>
>>>Terry
>>
>>Because I always avoid macro expansion for speed reasons. In this case the difference is minimal, but I try to be consistent. :-)
>
>Yeah - Min-im-AL! :-)

A nanosecond her, and a nanosecond here, can accumulate to save your costomers microseconds, maybe even milliseconds. And time is money, you know! :-))

Kidding aside, I have seen noticable improvements by my approach in functions which are used inside loops.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform