Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Bug with views and tableupdate ?
Message
 
To
30/03/2000 10:06:48
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00352711
Message ID:
00352979
Views:
16
Pascal,
What happens if the DLUD field in the second (not updateable) table is removed from the view? Does the update still have problems? Also, have you checked in the View Designer to be sure that the correct DLUD field is checked for updating?

HTH
Barbara

>I have a problem I'm fighting with since a while which I think is a bug (in VFP5.0) :
>
>I have a view which contains a table with several
>updatable fields and is joined to another table (without updatable fields). Both tables have a field called DLUD (which is a timestamp), but only the one of the first table is in the view (and updatable). When I try to update the field with the common name (DLUD) I get an update conflict. Updating the other fields in the view works as expected. I'm sure I'm picking the right field. I'm sure noone else is working on the tables so there can be no update conflict !!!
>When I force the update with tableupdate(2,.t.) then it works, as well when I use as WHERE clause only the key field.
>
>Anyone any idea ?
Barbara Paltiel, Paltiel Inc.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform