Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Fastest way to TOUCH a DBF without changing data?
Message
De
18/12/2006 16:16:25
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Divers
Thread ID:
01178674
Message ID:
01178711
Vues:
19
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform