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"
