David, To the best of my knowledge computed columns defined in a view are created with the NOTE datatype. That is way you get the line size limitation error message.
Jim Bentley American Celiac Society [email protected] tel: 1-504-737-3293 ________________________________ From: Alastair Burr <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Mon, May 31, 2010 9:56:04 AM 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" > > >
