Alastair An interesting idea.To do that however, I?d have to handle this with a temporary table,right?Then insert the SELECT into thetemp table?Or is there a way in a VIEWdefinition to set column types that I?m not aware of?I thought R:Base would normally follow thecolumn type of the original column.
David "David Blocker [email protected] Office: 781-344-1920 Cell: 339-206-0261" -----Original Message----- From: Alastair Burr [mailto:[email protected]] Sent: Monday, May 31, 2010 10:56 AM To: 'RBASE-L Mailing List' Subject: [RBASE-L] - Re: Getting Error Message on View: ?Row length exceeds maximum of 4,096 characters? David, I suspect that R:Base is changing the type of a column or columns in the view so that the new type is longer than the original. If so, you probably need to define the data types specifically. Regards, Alastair. From:David Blocker Sent: Monday, May 31, 2010 3:38 PM To:RBASE-L Mailing List Subject: [RBASE-L] - Getting Error Message on View: ?Row length exceeds maximum of 4,096 characters? Using R:Base 7.1, I am modifying a long standing table and view in an application, adding 22 columns.The modification to the table works just fine, and the table ends up with 280 columns in all. I now am trying to modify a view that while wide, in concept is very simple.It?s a ?TOTALS view? from this type of SELECT command: CREATE VIEW PayrollSummary (column name list) AS + SELECT Column1, column2, column3, column4, column5, column 6 + SUM (cola),+ SUM (colb),+ SUM (colc),+ Etc. GROUP BY Column1, column2, column3, column4, column5, column 6 The command gives me this error message: ?Row length exceeds maximum of 4,096 characters? I tried the same command in 7.6 and 9.0:While the actual text of the message is different in 9.0 (?new table is wider than 4096 bytes?), the gist is the same. My question is: How is this possible? The original TABLE has 280 columns, the view has 264 columns.The table is OK but the view is NOT? What work around exists for this? David Blocker "David Blocker [email protected] Office: 781-344-1920 Cell: 339-206-0261"
