General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
I am using a remote view on VFP6. I set OPTIMISTIC TABLE BUFFERING (5).
From the command line I open the remote view, I write
REPLACE logicalfield WITH .T. ALL
CC = TABLEUPDATE(.T.,.T.)
and CC is always NO
Then I try
REPLACE logicalfield WITH .T. FOR orderfield < 4
which makes three replacements and then
TABLEUPDATE(.T.,.T.)
REQUERY()
I get the uncommited changes mistake, then I insist for a second time
TABLEUPDATE(.T.,.T.)
REQUERY()
I get the uncommited changes mistake, then I insist for the third time (remember, 3 replacements were made before)
TABLEUPDATE(.T.,.T.)
REQUERY()
And then it requeries. What is wrong. Shouldn't the second TABLEUPDATE parameter force the whole table updating.
Thank you for any idea,
Eduardo
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only