Albert I understand the concept. But it seems unnecessary in thecurrent situation. The original PAYROLL table columns used in the view are:
The six columns used in the GROUP BY clause: ColleagueID: Text 8 PP: Text 4 LastName: Text 20 FirstName: Text 20 SEX: Text 1 SSNO: Text 11 The remaining columns that are SUMmed are ONE Numeric Column (Hours) 257 Currency columns So two questions arise: 1.Whereand why would R:Base be trying to change the data type? 2.Whydid R:Base NOT do this in the past with this view?The view used to have 242 columns in it.The ONLY changes I made were to add the 22new columns added to the PAYROLL table, with SUM(columname). The new column names are not reserved words.And ANSI is SET OFF. David Blocker "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 employeesTo 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 employeesAlbertDavid 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] the message SUBJECT, put just one word: INTRO================================================TO UNSUBSCRIBE: Send a plain text email to [email protected] the message SUBJECT, put just one word: UNSUBSCRIBE================================================TO SEARCH ARCHIVES:Send a plain text email to [email protected] 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.================================================
