Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Fastest way to TOUCH a DBF without changing data?
Message
 
 
To
18/12/2006 15:38:47
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
01178674
Message ID:
01178707
Views:
15
That seems like a good one. For that matter, I wonder if you could just say:
Update yourtable set field1=field1 where .F.
I wonder if it would still change the file's timestamp by just doing that?

>
>Update yourtable set field1=field1 where Recno()=1 && replace field1 with the actual name
>
>>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!
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform