General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
I have a view defined as the following sql select statment:
select prd_dev.*, deleted(), prodvend.dsprod ;
from prd_dev left outer join prodvend on (prodvend.cdprod = prd_dev.cdprod) order by prodvend.dsprod
Only the fields of the table prd_dev has been marked as updatable
fields.
I have edited the view using tablebuffering = 5 (opt. table buff.) and when I try to tableupdate(), it returns .f. and the error message is 'cannot insert blank row from a view into it's base tables'. If I try again, I receive another error 'uniquiness of index 'x' is violated'.
It seems very strange, since the tableupdate() insert the record on table prd_dev, but try to insert a record also on prodvend, and I don't want that behavior. The table prodvend is defined on view only to recall the product description, and the only field of this table is not marked as updatable or key field on view definition.
Any help will be apreciated.
Thanks for all!
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