|
The print facility will print all columns that
are retrieved by a query. To limit the number of columns to print,
you can either use the Windows Designer to rewrite the underlying
query, or you can set the column to non-displayed. All columns
retrieved by a query will be printed in table orientation.
Note the following:
|
·
|
If all columns do not fit on one row (i.e. the width of the
paper), the labels and each record are printed on multiple lines.
When multiple lines are used, each column will start at the nearest
tab stop, which are set each 15 character positions. The records
will be separated by a blank line. When all columns do fit on one
line, these tab stops and blank lines will not be used. |
|
·
|
Only "ordinary" data columns are printed. This does not include
OLE Containers, Bitmap Images, etc., these cannot be printed
directly. |
|
·
|
The data in LONG and CLOB fields is truncated. If you print
data from a spreadsheet (grid box), the data will be truncated to
the width of the column. If you print data from a non-spreadsheet
window, the data will be truncated to the line width. |
|
·
|
The print-related actions can be used in decisions,
SqlScript() etc. but you
cannot pass parameters to them. For this reason, the only relevant
use in decisions should be to have a decision check whether the
window contains records at all, and then either to print the
records, or to disable the print options/buttons. |
|
·
|
To be able to print data, you must put focus on a window, and
the window must contain data. You cannot work the other way
round. |
|
·
|
By default, all QUERIED records are printed. To limit the
number of records to print, perform a relevant query first, and
then use the Print option. |
|
