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 <[email protected]> Im Auftrag von MB Software Solutions, LLC Gesendet: Mittwoch, 2. Oktober 2019 20:10 An: [email protected] 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] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
