> I didn't try creating the view with aliases yet as it is not a function of > the view designer. It would have to be done with code, and I haven't ever > created a view with code yet.
Dan, If you right-click in the left-hand panel of the view-designer (but not on any on the boxes) you get a menu box popped-up with an alias name option (among other things). From there you can change the names of your columns for the view in question. Razzak/Anybody - what is the current limit on table/column names being different? As I remember, it used to be the first 8 characters but I though it had changed in more recent versions. Is it the full 18 characters now or is there still some lower limit? Regards, Alastair. ----- Original Message ----- From: "Dan" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, April 11, 2002 3:38 PM Subject: Trouble with REPORTS > Ok, > Starting over. I am now using the latest greatest version 6.5++ build > 1.851xRT03. > > Without performing the work around suggested earlier (select as for my > view) I recreated my view with R:Bases' view designer. Created a new > Report. Placed 4 columns on the report. Saved it. Ran it... and > crashed. Restarted Rbase and looked at the form. Guess what. One of my > columns is GONE. I moved another just slightly, and tried to > save..... Hmmm, now the one that is gone is out of the margin (this rings > a bell) > (Bill, yes I tried the select all in each area.... that column does not > exist. (maybe it is out of phase with this reality)) > So... now what. Back to workarounds? or should I just learn to not create > columns in my tables that have nice descriptive names like > FRRepGroupNum or FRGroupInactivate. > > Yes, I did show version to be sure I am running the latest. > Yes, I did check for lost or stray things on the report. > Yes, I now have less hair than I did yesterday. > > Next Idea? > > I didn't try creating the view with aliases yet as it is not a function of > the view designer. It would have to be done with code, and I haven't ever > created a view with code yet. > > > Thanks, > Dan > > > > Dan Champion > Champion Solutions > www.championsolutions.net > (616) 453-7225 > > > ================================================ > 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/
