Thanks Gunnar and R:azzak: >>> Take your time and create a one-time script to alias each column as you wish. Remember, you only have to do this once. <<< This is the approach I am using, but it would be nice to be able to import a "view" of the Server table into R:Base....maybe in Version 9??? Since I "discovered" that I can re-use the Alias name and the system will add sequential numbers, it sure saves a lot of time...
>>> Use R:BASE Turbo V-8 that handles long column and table names accordingly. <<< The problem is not the long names but they use spaces and special characters as well. I will likely upgrade to V-8 in the near future but in the mean time I need to finish this part of the application this afternoon as my boss is demonstrating it in Albuquerque tomorrow morning. Everyone is amazed on how fast this application was developed...a true real life testament to R:Base. Javier, Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln., Suite #101 Phone: 913-829-0888 Fax: 913-649-2904 Cell: 913-915-3137 ================================================ Attention: The information contained in this message and or attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from all system and destroy all copies. ====================================================== -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of A. Razzak Memon Sent: Sunday, January 06, 2008 11:23 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: SATTACH At 11:32 AM 1/6/2008, Javier Valencia wrote: >I have the restriction that I cannot modify the access database or add a >view there....is there a way to do this? Javier, Generally, when you are restricted to do anything with "other" databases, you have to find a swift solution to work with your existing version of R:BASE. Under such circumstances, you have at least two options: Take your time and create a one-time script to alias each column as you wish. Remember, you only have to do this once. OR Use R:BASE Turbo V-8 that handles long column and table names accordingly. http://www.rbase.com/rbg8/ http://www.rbase.com/rbg8/rbaseforeveryone.jpg (R:BASE for Everyone!) You pick the best option that meets your needs! Very Best R:egards, Razzak.
