Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is bug in updateable view resolved in VFP 6.0 ?
Message
From
23/07/2001 05:54:43
 
 
To
23/07/2001 05:45:28
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00533802
Message ID:
00533806
Views:
10
>I'm still using VFP 5.0 and I've bumped several times into a bug with updatable views. I'm wondering if it still exists in later version of VFP.
>
>The bug is (I suppose it's a bug and a known one) : a updateable view seems to try to update tables which aren't marked updateable. Seems to occur when several tables are joined and only one of them has to be updated, and when new records are created in the view.

I think I already found a workaround ! For those who're intrested and as far this solution didn't already appear on Universal Thread (which I can't imagine) :
just indicate the primary key in the update tab of the view, of the table on which the error occurs EVEN if that table isn't updateable (thus, it doesn't have any updateable fields).
Previous
Reply
Map
View

Click here to load this message in the networking platform