Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
View bug?
Message
De
29/06/2000 12:08:08
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
View bug?
Divers
Thread ID:
00386510
Message ID:
00386510
Vues:
44
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
Fil
Voir

Click here to load this message in the networking platform