The Data Wizard


The Data Wizard appears automatically when you add a data component to the screen. The Data Wizard explanation for each Data Component under the Objects Tree is described below. It is in the Data Wizard that you link data components to the database(s) of your choice and form joins, table selection, etc. All the necessary SQL and server-messaging is produced by JDesignerPro automatically when you have completed the Data Wizard settings for a particular object.

JDesignerPro can access any ANSI SQL-compliant database which can be driven by an ODBC or JDBC driver. If you have a native JDBC driver for your database you can avoid using ODBC or ODBC drivers. However, you can use the JAGGServer with ODBC by running a JDBC to ODBC bridge available from a companies such as Intersolv. Compatible and tested Databases include Oracle® 7+, Informix®, Sybase® 10+, MS-SQL Server™ 3+, MS-Access™ 4+, MS-FoxPro™ 3+, Lotus Approach™, IBM DB2®.

Each screen you build with JDesignerPro can be built over a different database. In fact you can have different databases accessed by separate components on the same screen. Because of memory and caching requirements, you should restart JDesignerPro for each new screen design. Between each screen build session we recommend clearing your browser’s memory cache. This can be done in the Netscape Navigator by choosing the menus: Options / Network Preferences / Cache / Clear Memory and Disk Caches. In the MS-Internet Explorer: View / Options / Navigation / Clear History.

Selecting a Dataset

The Selecting the Data section applies to each of the Data Objects. This section includes Select a Data Source, Select Table, Select Columns descriptions. For the Component-specific settings, see that component's description below under Data Wizard - Component Settings.

  1. Select a Database
  2. Select Table
  3. Define Keys

Component Settings

The previous section describes the first three Data Wizard screens, which are the same for all Data Objects. Once the data are chosen, each Data Component has unique settings that affect its design. Each of the Data Objects is described here .

  1. Column Settings
  2. Grid Settings
  3. Search Panel
  4. Result List
  5. Report Definition
  6. Chart Definition
  7. E Mail
  8. Alpha Paging