SET Options

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.

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'

3 rows returned
>

Form View

>SET AUTODISPLAY FORM
> select company, contact, city, state from customers where company='systems'

Press <RETURN> to continue, 'Q' to quit, or '/' to stop paging ...

Press <RETURN> to continue, 'Q' to quit, or '/' to stop paging ...

3 rows returned
>

top