Emmitt You hit the nail on the head: that?s the issue.Thanks to everyone who chipped in here, butthe problem is that R:Base stores View definitions in the SYS_VIEWS table andthe field is limited to 4096 characters.
Razzak, what about in a future version changing that fieldto VARCHAR to allow for larger view definitions?(Yes, I?ll go through the proper channels torequest this!) In the meantime, the workaround I came up with is tocreatea TEMP table and do an INSERTusing a SELECT with the same fields I wanted in the view definition. David "David Blocker [email protected] Office: 781-344-1920 Cell: 339-206-0261" -----Original Message----- From: Emmitt Dove [mailto:[email protected]] Sent: Monday, May 31, 2010 01:29 PM To: 'RBASE-L Mailing List' Subject: [RBASE-L] - Re: Getting Error Message on View: ?Row length exceedsmaximum of 4,096 characters? David, This is apparently a limit on the length of the view definitionwhich must be stored in SYS_VIEWS. SYS_COLUMN_LIST in SYS_VIEWS is a NOTE datatype, which is limited to 4096 characters. EmmittDove Manager,Converting Applications Development EvergreenPackaging, Inc. [email protected] (203)214-5683 m (203)643-8022 o (203)643-8086 f [email protected] From: [email protected][mailto:[email protected]] On Behalf Of David Blocker Sent: Monday, May 31, 2010 12:46 To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Getting Error Message on View: ?Row lengthexceedsmaximum of 4,096 characters? 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: Where and whywould R:Base be trying to change the data type? Why did R:BaseNOT do this in the past with this view? The view used to have 242 columnsin it. The ONLY changes I made were to add the 22 new columns added tothe PAYROLL table, with SUM(columname). The new column names are not reserved words. And ANSIis SET OFF. David Blocker "DavidBlocker [email protected] Office: 781-344-1920 Cell: 339-206-0261" -----OriginalMessage----- 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 lengthexceedsmaximum of 4,096 characters? David, if you create a temp table with the columns typed as you want, but leaveit empty, you can use it as the first table in the view, and that will definethe column types for you in your view. An example of this is when you combinetext columns in a view they usually come out as NOTE. CREATE VIEW empFullName(EmpID, FullName) AS + SELECT EmpID, (fName & lName) from employees Toresolve this issue, CREATE TEMP TABLE tmpFullName ( + EmpID INTEGER, + FullNameTEXT (100) ) CREATE VIEW empFullName (EmpID, FullName) AS + SELECT EmpID,FullName FROM tmpFullName + UNION + SELECT EmpID, (fName & lName) fromemployees Albert David Blocker wrote: > > Alastair > > > > Aninteresting idea. To do that however, I?d have to handle this with > atemporary table, right? Then insert the SELECT into the temp > table? Or isthere a way in a VIEW definition to set column types > that I?m not awareof? I thought R:Base would normally follow the > column type of the originalcolumn. > > > > 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 asyour Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME,DIGEST, RESEND, HELP) ================================================ TO SEEMESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In themessage SUBJECT, put just one word: INTRO================================================ TO UNSUBSCRIBE: Send a plaintext email to [email protected] In the message SUBJECT, put just one word:UNSUBSCRIBE ================================================ TO SEARCHARCHIVES: 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 messagebody, place any text to search for.================================================
