Database Toolbox

Viewing Query Results

After running a query in the Visual Query Builder, you can view the retrieved data by

• Typing the variable name in the MATLAB Command Window to view it there, or
• Double-clicking the variable in the VQB Data area to view the data in the Array Editor

The VQB Display menu provides additional options for viewing data:

• Relational Display of Data
• Chart Display of Results; for example, a pie chart
• Report Display of Results in a Table
• Customized Display of Results in the Report Generator

Use the saved query from the earlier example, basic.qry.

1. Select Query -> Preferences and set Read NULL numbers as to 0.
2. Select Query -> Load.
3. In the Load SQL Statement dialog box, select the File name, basic.qry. and click Open.
4. In the VQB, type a value for the MATLAB workspace variable, for example, A, and then click Execute.

Specifying Preferences for NULLS, Data Format, and Error Handling

Relational Display of Data

© 1994-2005 The MathWorks, Inc.