Table name is not displayed on drop down list in SQL map (SCI65104) *|* -A3F13B039E0D95F285257918003EA70D- *|*

Table name is not displayed on drop down list. On the Query tab of an input record's field in an SQL map the drop down menu that shows the Result Set Column Information does not show the table name.

This display is controlled by the ODBC Drivers not the Map Editor code. If the drivers return the table name then that will be added in front of the column name. For example if connecting to a MS SQL Pubs database and selecting from the sales table the Stor_id column would show as: Sales_Stor_idSales is the table name and Stor_id is the column name. The Oracle ODBC Drivers are not returning the table name information which is why the table name is not present with the column name in the map that connects to an Oracle database. To get the table name to show with the column name the following could be done.Modify the query to specifically name the columns that had the same name. Example:select table1.field1 as table1_field1 table2.field1 as table2_field1 * from table1 table2 where.......The SQL query can list out all of the fields instead of using "*" .