Here is the code for UPDATING one view form the other view:
The views are created and I can manually edit data with no problem.
CREATE TEMP VIEW View_OrdHead (Control#, ShipDate, FreightPro) +
AS SELECT Control#, Shipdate, FreightPro +
FROM OrderHeader WHERE Control# IN (&vControlList)
CREATE TEMP VIEW View_BOLHead (Control#, ShipDate, FreightPro) +
AS SELECT Control#, Shipdate, FreightPro +
FROM BOLHeader WHERE Control# IN (&vControlList)
-- Update OrderHeader, OrderShip & BOLHeader w/ Shipdates, FreightPros
then delete nulls.
UPDATE View_OrdHead SET FreightPro = T2.FreightPro FROM +
View_OrdHead T1, View_BOLHead T2 WHERE T1.ShipDate = T2.ShipDate
AND +
T1.Control# = T2.Control#
This is where I get the I/O problem.
Jim
________________________________
From: [email protected] [mailto:[email protected]] On Behalf Of
[email protected]
Sent: Saturday, December 05, 2009 9:28 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: I/O PROBLEMS WITH SIMPLE VIEWS
If a single-table view has an "order by", that also makes it not
editable.
I agree with others -- something in your view makes it not-editable.
Maybe post your view syntax.
Karen
Jim,
Just because a view is a single table view does not automatically make
it updateable. If for example it contains a GROUP BY statement then it
is NOT updateable. There are other syntax elements that might make a
single table view un-updateable.
