Scripting - GridOptions

The GridOptions statement specifies options about how a grid is to be displayed. This is useful for embedding in a query.

Specify the following:

• GroupBy. Whether (Y or N) the grid is to show the Group-By box
• RowNum. Whether (Y or N) the grid is to show Row Number.
• VarHeight. Whether (Y or N) the grid rows are to be variable-row height.
• Totals. Whether (Y or N) the grid is to show Totals at the bottom of the grid.

Example:

--aqt gridoptions,rownum=n,totals=y

select * from test.employees;