Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problems with simple View
Message
De
10/04/2001 17:50:59
 
Information générale
Forum:
Visual FoxPro
Catégorie:
The Mere Mortals Framework
Divers
Thread ID:
00494081
Message ID:
00494193
Vues:
14
>i have this view:
>SELECT Ubcargo.*, Cargo.cdescrip AS cargo;
> FROM ofertas!ubcargo, ofertas!cargo;
> WHERE Ubcargo.icargoid = Cargo.iid;
> AND Ubcargo.iubid = ?vp_iubId
>
>when use in the project manager work fine, but when i put in Busines object child, (i check Requery if parent changes) where the parameter is a integer value send me this error message:
>
>An empty row cannot be inserted from a view in its table or tables base (Error 1547) While a view is being updated, is being inserted a new empty registry (without modified fields) in one of the tables bases of the view. check of which each registry that is inserted from a View in a table base has at least a field that has been modified in the View before the update of the Vista.
>
>this error show in requery method from the BO, lnRetVal = REQUERY()
>
>that I am making bad?
>
>Best Regards
>
>Francisco Morosini

Check the tables property of the view using EView or DBGETPROP. Make sure the only table listed is the one that you want to update.
Erik Moore
Clientelligence
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform