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 16:16:25
 
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
01178674
Message ID:
01178711
Views:
16
If you want to 'touch' a table then really touch it i.e. change some field value in explicit way. Doing differently you open yourself (your application) to any kind of surprises. Btw, replacing values is extremely fast and efficient our days.

>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!
Edward Pikman
Independent Consultant
Previous
Reply
Map
View

Click here to load this message in the networking platform