Dennis All but one of the 250 or so fields being summed are CURRENCY and when viewed, they show on screen as currency.
David "David Blocker [email protected] Office: 781-344-1920 Cell: 339-206-0261" -----Original Message----- From: Dennis McGrath [mailto:[email protected]] Sent: Friday, June 11, 2010 03:28 PM To: 'RBASE-L Mailing List' Subject: [RBASE-L] - Re: Row size exceeds 4096 bytes It probably uptypes the data to double ifit is not currency. Dennis McGrath ------------------------------------------------------------ From:[email protected][mailto:[email protected]] On Behalf Of David Blocker Sent: Friday, June 11, 2010 2:18PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Row sizeexceeds 4096 bytes Karen Thanks for the suggestion ? with 1 minor change I used it and it?s muchfaster than the cursor program I had created. Instead of INTERSECTing the 2temp tables ? unacceptable because it created a PERMANENT table and I needed a TEMPtable that could be regenerated whenever needed, as a view would be ? I justcreated the Temp structure of the final table and did a 2 table select toinsert the rows into the final table. The fascinating thing about all this, STILL unexplained as far as I cansee, is that it?s NOT that the SELECT is too big, or has 2 many columns. The 2 table select works just fine. It?s that there seems to be a limitof how many SUM( ) expressions a SELECT can have that I?m running into,but it gives the error message about ?Row length excees maximum of 4.096characters?. Does the internal table R:Base creates when you do a SELECT generateWIDER columns if it?s a SUM? David "DavidBlocker [email protected] Office: 781-344-1920 Cell: 339-206-0261" -----OriginalMessage----- From:[email protected][mailto:[email protected]] Sent: Friday, June 11, 2010 08:27AM To: 'RBASE-L Mailing List' Subject: [RBASE-L] - Re: Row sizeexceeds 4096 bytes David: Can't remember if youended up solving this, but I had an idea and it doesn't seem like it would bevery hard: 1. Create 2 temp tables with half of the columns ineach. Insert data into each of the tables, including those 4 or 5"group by" columns you have. 2. Then just do an INTERSECT table1 WITH table2 FORMINGendingtable That should give you a table with all the columns, and I don't think any of thecommands would exceed the row length size. Karen
