AUTODISPLAY
SET AUTODISPLAY < LIST | FORM >
AUTODISPLAY changes the way OdxSql displays retrieved data, between list
view and form view.
- List view (default) displays the column names at the top of each page,
followed by the detail data. If possible, multiple records will be displayed
on each page. Page length and width are defined by the SET PAGELENGTH
n and SET PAGEWIDTH n options. Columns are wrapped according to the
pagewidth setting. The more columns selected, the less data visible
on the page.
- Form view displays each column in a separate line and each record
on a separate page. Column names are displayed to the left and column
data to the right of the screen.
Example
List View
>connect orders.env
Connected to C:\omnidex\Demodata\orders.env
>SET AUTODISPLAY LIST
>select company, contact, city, state from customers where
company='systems'
COMPANY
--------------------------- |
|
CONTACT
-------------- |
CITY
------------ |
ST
-- |
|
Dynamic Information Systems Corporation |
|
Mark S. Trasko |
Boulder |
CO |
|
Camco Systems |
|
Leo Tsatsaroms |
Nunawading VIC |
|
|
ASK Computer Systems, Inc |
|
Larry Hill |
Santa Clara |
CA |
|
Form View
>SET AUTODISPLAY FORM
> select company, contact, city, state from customers where company='systems'
COMPANY |
Dynamic Information Systems Corporation |
CONTACT |
Mark S. Trasko |
CITY |
Boulder |
ST |
CO |
Press <RETURN> to continue, 'Q' to quit, or '/' to
stop paging ...
COMPANY |
Camco Systems |
CONTACT |
Leo Tsatsaroms |
CITY |
Nunawading VIC |
ST |
|
Press <RETURN> to continue, 'Q' to quit, or '/' to stop
paging ...
COMPANY |
ASK Computer Systems, Inc |
CONTACT |
Larry Hill |
CITY |
Santa Clara |
ST |
CA |
Top
|