Javier I am in the same position, an access DB with column names like date name and so on.. What I do is this: 1. SET ANSI OFF ;That alows me to attach with naming in R:BASE reserved list 2. Then I project my own temp table with the columns I need and rename the columns I want with a different name with the NO CHECK option. 3. In my forms and reports I use only my temp RBASE tables 4. In the case I need to update tne access DB I do from eep in my forms
Gunnar Ekblad -----Ursprungligt meddelande----- Från: [email protected] [mailto:[EMAIL PROTECTED] För javier valencia Skickat: den 6 januari 2008 17:32 Till: RBASE-L Mailing List Ämne: [RBASE-L] - SATTACH I am using SATTACH to attach Access tables. The tables I need to attach have a large number of columns with names that are not R:Base valid as they contain spaces and characters such as "(" and "%" , the tables have very few records and I need only a couple of columns per table. I was hoping to be able to do something like: SATTACH 'Scenario Description' AS WTCostData USING 'Acces Col1%', + 'Access Col(2)' ALIAS RBCol1, RBCol2 However, when I do this, the command assigns the alias to the first 2 columns and then prompts for aliases for the rest of the columns. Since some of the tables might have a large number of columns with very long names, the command to do this SATTACH would be huge. I finally found (by accident) that if you assign the same Alias to all the columns, the software adds a sequential number to the duplicate aliases: SATTACH 'Scenario Description' AS WTCostData USING ALL + ALIAS SDCol,SDCol,SDCol,SDCol,SDCol,SDCol,SDCol,SDCol,SDCol,SDCol The resulting R:Base table has columns labeled: SDCol, SDCol_1, SDCol_2, SDCol_3, SDCol_4, SDCol_5, SDCol_6, SDCol_7, SDCol_8, SDCol_9 Which is a big improvement in the coding. However, I would like to be able to attach what would essentially be a view of the server tables with only a few columns. I have the restriction that I cannot modify the access database or add a view there....is there a way to do this? Javier, Javier Valencia, PE Sr. Project Manager Universal Asset Management, L.L.C. 801 Westchester Ave. Harrisonville, MO 64701 Phone: 816-887-4011 Fax: 816-887-1960 Cell: 913-915-3137
