2012

Table Of Contents
The Data View window provides a great deal of flexibility in how records are
displayed. You can
Move or resize columns
Hide columns to remove them from the Data View window display
Sort column data in ascending or descending order
Freeze a column or combination of columns so that they stay in place and
do not scroll with the horizontal scroll bar
Align text within individual columns
Apply a variety of font styles and sizes to the Data View window display
Column formatting and database table sorts in the Data View window are not
stored. This information is discarded when you open a new database table or
close the current table. If you want to create and save a formatted report, you
must copy the contents of the Data View window to the Clipboard and paste
it into an external program such as Microsoft Excel. You can then use the
external program to apply and save the desired formatting. For details about
creating a template, refer to the documentation of the external program that
you are using to format the data.
Database Views and External Queries
Some database management systems support views. Views provide additional
ways to display data from a database table. For example, you can use a view
to display a subset of the overall database table. You can also use views to
define relationships between database tables and create a new table that
contains combined records from the original database tables.
Database systems that do not support views can produce similar results with
queries. Refer to your database system documentation for information about
creating and working with views and queries.
Views and external queries are displayed in the Data Sources node of the
dbConnect Manager. External queries are queries created and stored outside of
the program but within an external database system. You can work with
external queries and views as you would work with any other database table.
You can view or edit them in the Data View window, construct queries based
on them, and create links and labels based on their records.
To open a database table for viewing or editing
1 Click Toolsmenu Palettes DbConnect.
View Data in a Database Table | 2009