At 10:38 AM 4/11/02 -0400, Dan wrote: >... 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)
Using the latest version, now you have BETTER ERROR MESSAGES AND CONTROL in Designers. >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. Following is a very simple example of how to use SELECT AS when creating a VIEW. SET ERROR MESSAGE 677 OFF DROP VIEW UpdatesView CREATE VIEW `UpdatesView` AS SELECT + U1.UpdateID AS UpdateIDNumber, + U1.BriefDesc AS BriefDescription, + U1.CatID AS CategoryIDNumber, + UC1.CatText AS CategoryText, + U1.FileN AS FileNumber, + U1.Active AS ActiveStatus, + U1.UpdateType AS TypeOfUpdate + U1.Expires AS ExpirationDate + FROM UpCat UC1, Updates U1 WHERE U1.CatID = UC1.CatID SET ERROR MESSAGE 677 ON Enjoy and make sure to have fun! Very Best Regards, Razzak. ===================================-============================ Official R:BASE List Server: mailto:[EMAIL PROTECTED] RBTI Events/Training: http://www.rbase.com/events R:DCC Members: http://www.rbase.com/rdcc Developers' Conference 2002: http://www.rbase.com/conference ================================================================ R:BASE, Oterro & R:Tango are registered trademarks of RBTI. ==================================-============================= ================================================ 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/
