Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Is bug in updateable view resolved in VFP 6.0 ?
Message
De
23/07/2001 05:54:43
 
 
À
23/07/2001 05:45:28
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00533802
Message ID:
00533806
Vues:
9
>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).
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform