Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Bug with views and tableupdate ?
Message
From
30/03/2000 10:06:48
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Bug with views and tableupdate ?
Miscellaneous
Thread ID:
00352711
Message ID:
00352711
Views:
32
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 ?
Next
Reply
Map
View

Click here to load this message in the networking platform