Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Dear Tableupdate
Message
From
28/02/2001 17:26:38
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Dear Tableupdate
Miscellaneous
Thread ID:
00480764
Message ID:
00480764
Views:
31
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
Map
View

Click here to load this message in the networking platform