Why bother with the views????
UPDATE OrdHead SET FreightPro = T2.FreightPro FROM +
OrdHead T1, BOLHead T2 +
WHERE T1.Control# IN ( &vControlList ) +
AND T1.ShipDate = T2.ShipDate AND +
T1.Control# = T2.Control#
Dennis McGrath
________________________________________
From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle
Sent: Monday, December 07, 2009 9:41 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: I/O PROBLEMS WITH SIMPLE VIEWS
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.
--- RBASE-L
=======================3D=======================3
D=
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
=======================3D=======================3
D=
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
=======================3D=======================3
D=
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
=======================3D=======================3
D=
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
=======================3D=======================3
D=
