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
You will see network traffic, however small, as the update occurs.
----------------------------- Michael Oke, II okeind@gmail.com 661-349-6221 -----------------------------
On Wed, Oct 2, 2019 at 11:10 AM MB Software Solutions, LLC < mbsoftwaresolutions@mbsoftwaresolutions.com> wrote:
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]
Yes, I was betting on that too. In a solution where there's tons of traffic from multiple users, this is the kind of stuff I'm trying to refactor to make this app more robust and less prone to issues.
On 10/2/2019 2:20 PM, Michael Oke, II wrote:
You will see network traffic, however small, as the update occurs.
Michael Oke, II okeind@gmail.com 661-349-6221
On Wed, Oct 2, 2019 at 11:10 AM MB Software Solutions, LLC < mbsoftwaresolutions@mbsoftwaresolutions.com> wrote:
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 MyTableOr 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]
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]
-
juergen＠wondzinski.de -
MB Software Solutions, LLC -
Michael Oke, II