General information
Category:
The Mere Mortals Framework
Title:
Problems with simple View
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only