When I CREATE VIEW, I ALWAYS use the (COLName1,COLName2 ...) "alias" feature before the "AS ...", even if I'm just using the same name as the source COLUMN.
Would this prevent Dan's problem? Later, Steve in Memphis > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On > Behalf Of Lawrence Lustig > Sent: Thursday, April 11, 2002 7:43 AM > To: [EMAIL PROTECTED] > Subject: Re: Trouble with Forms > > > > Using version 6.5 Windows R:base. > > Could it have ANYTHING to do with long column names? My tables and > > subsequent columns have long names, and I know that I ran into trouble > with > > long names before when the first 10 characters are the same. > > Yes, the problem does have to do with long column names. Older > versions of > R:Base reserved 18 spaces in the report definition for each > column placed on > the report. However, when you use a view, the name stored is actually > TableAlias.ColumnName, which can easily go over the limit. The > symptoms of > this problem: 1) spurious messages about something outside the margins and > 2) the offending columns would dissappear when you opened the report for > editing. > > As a work around, you can create shorter alias names in the view > definition > so no combination of table and column alias (plus the period to separate > them) exceeds 18 characters. I believe this problem is fixed in > more recent > versions of the program. > -- > Larry > > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: INTRO rbase-l > ================================================ > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: UNSUBSCRIBE rbase-l > ================================================ > TO SEARCH ARCHIVES: > http://www.mail-archive.com/rbase-l%40sonetmail.com/ > ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
