In MapInfo: Aliases for Column names are TEMPORARY and generated in an SQL. Simply add the column name in the Column section and type the alias in quotes after a space, no comma, and that will be the new field name in the resulting query. This will work after either a simple column name or after a calculated column. Remember column conventions such as no spaces, etc. You cant use the * to select all, but you may included each column individually. There maybe some limitation in the SQL wizard, so if you run out of space use the MapBasic window. To give it some permanence, put into a table name, and save the workspace, then the alias will be generated every time you open it. you can add other SQL operations at the same time , or simply rename the alias.
Select Real_Col_Name "Alias_Col_Name" from my table into Renamed Field In Access: Rename a field in a query Open a query in Design view. Place the insertion point to the left of the first letter of the field name in the design grid. Type the new name followed by a colon. Note If you're replacing the field name Expr1 (or Expr2, and so on) that Microsoft Access automatically assigned, replace only the name, not the expression that follows the colon. William "Woody" Woodruff Zoning Administrator Charter Township of Union, Isabella County, Michigan -84.80947000 43.61095100 2010 S Lincoln Rd, Mt. Pleasant, MI 48858 (989) 772 4600 EXT 41 Visit our web site at http://www.geocities.com/ctuzoning/index.htm -----Original Message----- From: Cinda Graubard [mailto:[EMAIL PROTECTED] Sent: April 20, 2004 15:49 To: [EMAIL PROTECTED] Subject: MI-L how to set a field alias, in MapInfo and/or Access? I need make an alias for primary key field in an Access Query (apparently so that the table can be edited once opened via ODBC from MapInfo?) but cannot figure out how to do that. Can anybody tell me how to do this, either from Access or MapInfo? If you can help but need more details about what I am trying to do, just email me directly. Thanks in advance, Cinda Graubard GeoMax --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11466 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11510
