SQLManager 
is an integral part of all MarketWide's programs and is accessible from all the MarketWide components. SQLManager serves multiple purposes in MarketWide crucial to its simplicity.
It helps maintain database and MarketWide objects such as tables, views and cubes; creates expressions, selects a database and table within a MarketWide program, and queries your databases. However, the most prominent use of SQLManager will simply be to select databases and tables to run campaigns and queries against.
The primary purpose of SQLManager is to make it easy to select databases and tables for use in other MarketWide modules. Additionally, SQLManager has several other useful features.
On the Database tab, in addition to choosing a table, you can view the table with QueryBuilder, create or edit a join, union, or query; or you can perform a limited number of functions on your tables.
On the MarketWide tab, you can view the content of a cube in QueryBuilder, create a new cube, or edit an existing cube.
The SQLManager toolbar provides shortcuts to commonly used SQL commands. Click an icon once to carry out the action represented by that icon.
Icon | Description | Menu Equivalent |
|---|---|---|
| Submits a refresh request to the host for the database. | File > Refresh Orders |
| Opens the Print dialog, allowing you to specify printing options such as printer selection and the number of copies printed. Clicking the properties button within this dialog allows you to adjust page options such as orientation as well. | File > Print |
| Exits the SQLManager module. | File > Exit |
| Selects all the components of the highlighted object. | Edit > Select All |
| Copies the currently selected object. | Edit > Copy |
| Copies the currently selected object and the headers to paste into a spreadsheet. | Edit > Copy with Headers |
| Deletes the currently selected object. | Edit > Delete |
| Allows the user to edit the selected object. | Edit > Edit |
| Allows the user to rename the selected object. | Edit > Rename |
| Opens JoinBuilder to create a new join. | Edit > New > Join |
| Opens UnionBuilder to create a new union. | Edit > New > Union |
| Opens QueryBuilder to create a new Query. | Edit > New > Query |
| Allows the user to expand all the objects under the criteria tree. | Edit > Expand All |
| Allows the user to collapse all the objects under the criteria tree. | Edit > Collapse All |
| Opens the appropriate module to edit the currently selected object. | Edit > Properties |
| Opens frequency distribution dialog on the currently selected field. | View > Frequency Distribution |
| Opens the selected table. | View > View Table |
Opens the DataExport application to transfer data to text files, and then to the database. | View > Export | |
| Sends the selected object into the QueryBuilder program. | View > Send to > QueryBuilder |
| Sends the selected object into the Analyzer program. | View > Send to > Analyzer |
-- | Selecting this option causes MarketWide applications to display the Table Change dialog when switching tables during report creation. | Tools > Prompt on Table Change |
-- | Opens the options dialog allowing you to select what descriptions you wish to be displayed for each field in a table. | Tools > Display Options |
