Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Inserting Records Through a View
Message
De
28/12/1999 19:37:20
 
 
À
28/12/1999 15:29:17
Information générale
Forum:
Visual FoxPro
Catégorie:
Visual FoxExpress
Divers
Thread ID:
00309437
Message ID:
00309616
Vues:
26
>Hi Guys
>
>I have a Presentation Object on a Form Presentation Object that is based on a View
>
>When I try to insert a record into this view i get the following error message:
>
>"Cannot insert an empty row from a view into its base tables(s)"
>
>What can I do to solve this
>
>Thank You
>
>Gary

This is usually because the view definition has updatable fields from more than one table. When you do a TABLEUPDATE(), VFP attempts to insert a record into both underlying tables. If you check your view, and find that only fields from a single table are set as updatable, remove all but the true updatable table name from the view's Tables property using DBSETPROP(). FWIW, my eView utility makes tweaking views like this much easier than wrestling with DBSETPROP commands. You can get here from the files section.
Erik Moore
Clientelligence
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform