SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 10967: Define Selection window behaves strangely when saving selection rules after saving an SQL query

DetailsHotfixAboutRate It
If you create and save a new SQL query in the SQL Query Window of the
SAS Campaign Management component, then change to the Define Selection
screen (View->Current View->Define Selection) and enter and save a
selection rule, the contents of the SQL Query previously created is
written to the database in place of the new selection rule.

Consequently, if you later try to open the selection rule, you are
instead taken to the SQL Query Window and the original SQL Query is
displayed.  This continues to happen for each subsequent selection rule.

To avoid the problem, press the 'New' icon before switching from the SQL
Query Window to the Define Selection window.


A Technical Support hot fix for this issue is available at:
   http://ftp.sas.com/techsup/download/hotfix/cam75.html


Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Campaign ManagementMicrosoft Windows NT Workstation7.54.0
Microsoft Windows XP Professional7.54.0
Microsoft Windows 2000 Professional7.54.0
Microsoft Windows 2000 Advanced Server7.54.0
Microsoft Windows 2000 Server7.54.0
Microsoft Windows 2000 Datacenter Server7.54.0
* 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.