Hi David,
What happens if you use only one col and one sum?
If that works, add the others one at a time.
Just my 2 cents,
Bernie Lis
----- Original Message -----
From: David Blocker
To: RBASE-L Mailing List
Sent: Monday, May 31, 2010 10:38 AM
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"
