Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problems with simple View
Message
From
10/04/2001 17:50:59
 
General information
Forum:
Visual FoxPro
Category:
The Mere Mortals Framework
Miscellaneous
Thread ID:
00494081
Message ID:
00494193
Views:
15
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform