How many bytes are used by currency columns? And, when summed, do they remain currency in the view or are they converted to something more expensive?
Ben On Mon, May 31, 2010 at 9:58 AM, David Blocker <[email protected]> wrote: > I ran further testing to see if perhaps I had a syntax error that was > messing things up. > > > > I restored the original file creating the view (PayrollSummary.VIE) which > just has a DROP VIEW command and a CREATE VIEW command. I ran it ? it > worked fine. I added only ONE new column I457 CURRENCY and immediately, when > I tried running it, got the error message ?Row length exceeds maximum of > 4,096 characters? > > > > Ideas? > > > > David > > > "David Blocker > [email protected] > Office: 781-344-1920 > Cell: 339-206-0261" > > -----Original Message----- > From: Albert Berry [mailto:[email protected]] > Sent: Monday, May 31, 2010 12:13 PM > To: 'RBASE-L Mailing List' > Subject: [RBASE-L] - Re: Getting Error Message on View: ?Row length > exceedsmaximum of 4,096 characters? > > David, if you create a temp table with the columns typed as you want, but > leave it empty, you can use it as the first table in the view, and that will > define the column types for you in your view. An example of this is when you > combine text columns in a view they usually come out as NOTE. CREATE VIEW > empFullName (EmpID, FullName) AS + SELECT EmpID, (fName & lName) from > employees To resolve this issue, CREATE TEMP TABLE tmpFullName ( + EmpID > INTEGER, + FullName TEXT (100) ) CREATE VIEW empFullName (EmpID, FullName) > AS + SELECT EmpID, FullName FROM tmpFullName + UNION + SELECT EmpID, (fName > & lName) from employees Albert David Blocker wrote: > > Alastair > > > > An > interesting idea. To do that however, I?d have to handle this with > a > temporary table, right? Then insert the SELECT into the temp > table? Or is > there a way in a VIEW definition to set column types > that I?m not aware > of? I thought R:Base would normally follow the > column type of the original > column. > > > > David > > > --- RBASE-L > ================================================ TO POST A MESSAGE TO ALL > MEMBERS: Send a plain text email to [email protected] (Don't use any of > these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, > SUSPEND, RESUME, DIGEST, RESEND, HELP) > ================================================ TO SEE MESSAGE POSTING > GUIDELINES: Send a plain text email to [email protected] In the message > SUBJECT, put just one word: INTRO > ================================================ TO UNSUBSCRIBE: Send a > plain text email to [email protected] In the message SUBJECT, put just one > word: UNSUBSCRIBE ================================================ TO SEARCH > ARCHIVES: Send a plain text email to [email protected] In the message > SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the > message body, place any text to search for. > ================================================
