MultiValue Tech Tip!

Dan Wagner was kind enough to supply the following tech tip to allow D3 AQL statements to scroll from TCL.

D3 Scroll AQL reports  (W option  

w{-}{number}

Displays the output of a list or sort command in a full screen window, allowing the user to scroll backward, forward, left, and right through the report.  If a minus sign (-) displays after the w option, then a wide virtual display is used to display the output of the AQL sentence.

The user can then scroll left and right a screen at a time, as well as up and down a screen at a time.

If a number is entered, that number of lines from the top of the first page are stored away as the header, and are displayed on each page. This may cause confusion for reports that display the page number within the header. The h option (hdr-supp) is automatically appended to any reports that do not include a heading entence.

A short help screen is available. while displaying the output to elaborate on the keystrokes.

example:
SORT VENDOR WITH YTD.PAID > "10,000.00" BY-DSND YTD.PAID VENDOR.NAME YTD.PAID PRIOR.YRPAID (W-2

SORT CASHRECEIPTS WITH CUST.NO = "000221" BY DATE DATE TOTAL AMT.PAD (W

The  (W option provides easy scrolling of all AQL reports .

I know you will find this extreamly useful and easy to add to any application software.

 

menu
menu