Previous issue Thread #969465

Bug/Issue : 32 of 55

TITLE: BUG: buffering 2 with no buffer or table buffering and REPLACE

VERSION: 09.00.0000.1720 and previous

EXPECTED: VFP have not to update data on different workarea

OBSERVED:
If you open a cursor into two workareas,
- workarea 1 with buffer 2
- workarea 2 with buffer 1 or 4 or 5
- put data into wa1
- when execute a REPLACE on wa2,
and update it, TABLEUPDATE return success
but VFP forced a tableupdate on wa1 and these values
go into the table.

REPRO with comment:

CLEAR
SET MULTILOCKS ON

CREATE CURSOR myCursor ( F1 I) && exclusive mode
APPEND BLANK
CURSORSETPROP("Buffering",2)

SELECT myCursor

REPLACE F1 WITH 100

? "FIELD ON ",ALIAS()," IS ",F1,CURVAL("F1")," STATUS :  ",GETFLDSTATE(-1)

? '******'
    USE DBF() IN 0 AGAIN ALIAS CLONE_CURSOR
    SELECT CLONE_CURSOR
    CURSORSETPROP("Buffering",5)
    ? "FIELD ON ",ALIAS()," IS ",F1," «««««« attention here"   ,GETFLDSTATE(-1)
    REPLACE F1 WITH F1+1
    ? "FIELD ON ",ALIAS()," IS ",F1," «««««« attention here"    ,GETFLDSTATE(-1)
    * next line update CLONE_CURSOR, but:
    * 1. update CLONE_CURSOR ???
    * 2. update myCursor 
    ? "UPDATE IT IS OK ?",TABLEUPDATE()
    ? "FIELD ON ",ALIAS()," IS ",F1," <<<<< attention here"    ,GETFLDSTATE(-1)
    USE
? '******'
SELECT myCursor
? "FIELD ON ",ALIAS()," IS ",F1,CURVAL("F1")," STATUS :  ",GETFLDSTATE(-1)
USE