Problem Note 9599: Query code is not updated after changing the input table using
Enterprise Guide
Enterprise Guide allows the user to change the table reference for input
into the Query Builder. For example, if you have two tables both with
the same column layout, you can run a query on one table, change the
input table to the second table, and rerun the same query without having
to rebuild the query code. The problem is that all the new table
references do not get updated in the query code and query builder
although the results will be correctly based on the new table.
To circumvent the problem, before resubmitting the new query, select the
Table tab in the query builder and RightMouse on the table header and
choose Properties, change the Alias to the new table name and then run
the query.
A Technical Support hot fix for Enterprise Guide 2.0 for this
issue is available at:
http://www.sas.com/techsup/download/hotfix/ent_guide20.html#009599
Operating System and Release Information
| SAS System | SAS Enterprise Guide | Microsoft Windows 2000 Professional | 1.3 | 2.05 | 8.2 TS2M0 | |
| Windows Millennium Edition (Me) | 1.3 | 2.05 | 8.2 TS2M0 | |
| Microsoft Windows NT Workstation | 1.3 | 2.05 | 8.2 TS2M0 | |
| Microsoft Windows 95/98 | 1.3 | 2.05 | 8.2 TS2M0 | |
| Microsoft Windows XP Professional | 1.3 | 2.05 | 8.2 TS2M0 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2003-05-29 10:34:04 |
| Date Created: | 2003-03-12 11:50:18 |