Dan, I sent this in an earlier mail, "Trouble with FORMS", so maybe you didn't see it. I don't know, but it might help if that 18-char issue is the problem.
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. HTH. Later, Steve in Memphis > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On > Behalf Of Dan > Sent: Thursday, April 11, 2002 9:39 AM > To: [EMAIL PROTECTED] > 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/
