Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
View bug?
Message
From
29/06/2000 12:08:08
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
View bug?
Miscellaneous
Thread ID:
00386510
Message ID:
00386510
Views:
46
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
Map
View

Click here to load this message in the networking platform