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 17:38:59
 
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
01178674
Message ID:
01178736
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.
No, VFP is smart enough to make no changes to the file, AFAIK.

>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
Reply
Map
View

Click here to load this message in the networking platform