I created two simple single table views so I can Update one of the tables.
The CREATE command worked fine and the views have only 5 to 7 rows each. The common columns of the two views are CONTROL# & MODEL# When I go to UPDATE one view from the other I get the I/O problem and RBASE claims there are no rows to meet the criteria. UPDATE View_OrdRows SET Shipqty = T2.Totship FROM + View_OrdRows T1, View_OrdShip T2 WHERE T1.Control# = T2.Control# + AND T1.Model# = T2.Model# I got out of the database then in again and the same problem arose. It has been years since I had an I/O problem. Jim There is plenty of free space on the drive.
