Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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!
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement