Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Update conflict
Message
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Title:
Miscellaneous
Thread ID:
00143536
Message ID:
00143621
Views:
24
> This is not a problem. This is the way to trap 'Update Conflict' using Views in VFP.
> You must be trying to update same record of the same table from two different session.

Thanks for your reply, Jayesh. The first form is basically a picklist, based on a grid. The record contents are not changed on this screen (and I've confirmed this with GetFieldStatus(). And it wouldn't account for the fact that if I add _two_ records, then delete, the error doesn't occur. This only happens if the view is empty, I add one record in another datasession, I requery the view, and delete that record.

> There is a property of a View, which sets 'Update Type' of the View. It has three values
>
> - Key and Modified Fields
> - Key and Updateable Fields
> - Key Fields Only.
>
>You must have 'Key and Modified Fields' set in your view. Change it to 'Key Fields only' and will work.

That's a good idea (although it doesn't make sense, since I'm not updating fields, just deleting). But I've already done that anyway, and it didn't help. :(
Previous
Reply
Map
View

Click here to load this message in the networking platform