Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Update conflict
Message
From
03/11/1997 08:51:12
Sonny Chouinard
CHCA Computer Systems Inc.
Lachenaie, Quebec, Canada
 
 
To
01/11/1997 00:30:50
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Title:
Miscellaneous
Thread ID:
00057582
Message ID:
00057945
Views:
34
>>I see that the wheretype is set to 3 (Key and modified fields). May be the update conflict is there. Did the client can update that view in under other conditions? If yes, maybe you should set it to 1 (key fields only). If not, the problem may be directly in the table. Does the PK in the table has a filter !Deleted() if same key?
>
>Can you tell me what wheretype parameter means?
>
>No, there is no update done externally.
>
>We do not use a filter for not deleted(). We are running with SET DELETE ON and have a tag on DELETED().

In the view designer, you have an update tab. In this page, you have a SQL WHERE CLAUSES.
This clauses, check the table for conflict when updated. It warns if the oldvalues and the
values in the table. If the values differs. There is an update conflict.
This clauses, you have 4 possibilities:

1- Key fields Only : Check just the PK fields listed in the update

2- Key and updatable fields : Check the PK and all updatable fields

3- Key and modified fields : Check the PK and all the fields modified

4- Key and timestamp : Check the PK and a timestamp field.

You can check also how it is updated. Using DELETE than INSERT or SQL UPDATE...
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform