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.
Jim Bentley American Celiac Society [email protected] tel: 1-504-737-3293 ________________________________ From: Jim Belisle <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Fri, December 4, 2009 12:15:35 PM Subject: [RBASE-L] - Re: I/O PROBLEMS WITH SIMPLE VIEWS David, They are both single table temporary views. Jim ________________________________ From:[email protected] [mailto: [email protected] ] On Behalf Of David Blocker Sent: Friday, December 04, 2009 12:09 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: I/O PROBLEMS WITH SIMPLE VIEWS Jim Are these updateable views? You can only use the UPDATE command on a view if the view represents a one table select, updating collumns that are the same as in the original table. A workaround is to CREATE TEMP TABLE, load the table with the data from your views, and update the tables. David Blocker "David Blocker [email protected] Office: 781-344-1920 Cell: 339-206-0261" -----Original Message----- From: Jim Belisle [mailto:[email protected]] Sent: Friday, December 4, 2009 01:03 PM To: 'RBASE-L Mailing List' Subject: [RBASE-L] - I/O PROBLEMS WITH SIMPLE VIEWS 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.
