I tried this code in the command window only that both views have !DELETED() in the WHERE clause of the SQL VIEW. It work as expected.
open database sample
USE VIEW4 IN 0
USE VIEW5 IN 0
CURSORSETPROP("BUFFERING",5,"VIEW4")
CURSORSETPROP("BUFFERING",5,"VIEW5")
DELETE IN VIEW4
SELECT VIEW4
BROW
DELETE IN VIEW5
SELECT VIEW5
BROW
TABLEUPDATE(1,.T.,"VIEW4")
TABLEUPDATE(1,.T.,"VIEW5")
REQUERY("VIEW4")
REQUERY("VIEW5")
SELECT VIEW4
BROW
SELECT VIEW5
BROW
JESS S. BANAGA
Project Leader - SDD division
...shifting from VFP to C#.Net
CHARISMA simply means: "Be more concerned about making others feel good about themselves than you are in making them feel good about you."
