You are touching an indexed field. VFP doesn't care what you are writing to that field, it just updates the table and subsequentally the index.
wOOdy
-----Ursprüngliche Nachricht----- Von: ProFox profox-bounces@leafe.com Im Auftrag von MB Software Solutions, LLC Gesendet: Mittwoch, 2. Oktober 2019 20:10 An: profox@leafe.com Betreff: Question regarding updates to backend DBF table
Scenario: VFP9SP2 on modern Windows operating system using DBFs. Let's assume NO BUFFERING for this scenario, but there IS an index (1 or more) using the MyField field in the .CDX file.
If the MyTable.MyField current value is "MyValue", will this code cause any network traffic with the backend table even though the value is the same?
REPLACE MyField WITH "MyValue" IN MyTable
Or is VFP smart enough to say "yeah, I'm not updating it with the same value. Next."
???
--- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus
[excessive quoting removed by server]