Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Moving from 7 to 9
Message
From
12/09/2006 07:58:02
 
 
To
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:
01152970
Views:
26
>>>>...
>>>>>
>>>>>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.

Like the Scots say: "Many a mickle makes a muckle" :-)
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.
Previous
Reply
Map
View

Click here to load this message in the networking platform