Using R:Base 7.1, I am modifying a long standing table andview in an application, adding 22 columns.The modification to the table works just fine, and the table ends upwith 280 columns in all.
I now am trying to modify a view that while wide, in conceptis 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, column6 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 isdifferent 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 has280 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"
