Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Fastest way to TOUCH a DBF without changing data?
Message
From
18/12/2006 18:29:34
 
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
01178674
Message ID:
01178755
Views:
16
You might want to experiment with these functions:
use xxxx
cursorsetprop('buffering',5)
setfldstate(0,2)
tableupdate(.t.)
use
However, it didn't work if the table has zero records. Perhaps you can experiment further?

>Is there a way more efficient than this (assuming no records are marked for deletion in normal use, and that if zero records, then there is not need for the TOUCH)?
>USE XXXX
>If RECC()>0
>  GOTO 1
>  DELETE
>  RECALL
>ENDIF
>USE
>
>Thanks!
Groet,
Peter de Valença

Constructive frustration is the breeding ground of genius.
If there’s no willingness to moderate for the sake of good debate, then I have no willingness to debate at all.
Let's develop superb standards that will end the holy wars.
"There are three types of people: Alphas and Betas", said the beta decisively.
If you find this message rude or offensive or stupid, please take a step away from the keyboard and try to think calmly about an eventual a possible alternative explanation of my message.
Previous
Reply
Map
View

Click here to load this message in the networking platform