Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SELECT - SQL and buffered table
Message
 
 
To
10/01/2001 10:29:26
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00461621
Message ID:
00461637
Views:
12
>Hi,
> thank you for information. I would like to know, why tableupdate() will fail in following situation?
>
>Situation
>
>I am using table buffering
>I have 10 fields in this table.
>I use REPLACE WITH command to replace 7 fields.
>Once I issue TABLEUPDATE(), it will be failed if any fields value (the less 3 fiels) modified by other users?
>Since I just update 7 fields but not the less, why it still fail?
>How to make it work like view, which will only check conflict for modified fields?
>
>Thank you

AFAIK (and that could be wrong), you can't. For buffered tables, it is an all or nothing deal. Can you switch to a view paradigm? Or is this not an option at this point in development?
Larry Miller
MCSD
LWMiller3@verizon.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform