----- Original Message -----
From: "MikeB" <[EMAIL PROTECTED]>
To: "RBG7-L Mailing List" <[email protected]>
Sent: Friday, January 21, 2005 3:10 PM
Subject: [RBG7-L] - Re: Page Breaks - Printing
> If they are plaintext, why not output them directly to file from a formated
> select?
>
> Notwithstanding, for quick display on the screen, output as HTML, but using
an
> *.HTA file extension will give you an almost instantaneous result on the
screen
> for viewing by using Launch TheOutPutFileName.HTA
>
Also, you can bypass the Select as HTML completely for quicker results as
follows using the RRBYW4 database
set width 120
out hold.hta
set heading off
wri '<html><HEAD>'
wri '<TITLE>My Custom Quickie HTA Report</TITLE>'
wri ' <HTA:APPLICATION ID="oHTA"'
wri ' APPLICATIONNAME=""'
wri ' BORDER="thin"'
wri ' BORDERSTYLE="normal"'
wri ' CAPTION="yes"'
wri ' ICON=""'
wri ' MAXIMIZEBUTTON="yes"'
wri ' MINIMIZEBUTTON="yes"'
wri ' SHOWINTASKBAR="no"'
wri ' SINGLEINSTANCE="no"'
wri ' SYSMENU="yes"'
wri ' VERSION="1.0"'
wri ' WINDOWSTATE="maximize"/>'
wri '<SCRIPT>'
*(
This function also retrieves the value of the commandLine property,
which cannot be set as an attribute.
)
wri ' function window.onload()'
wri ' {'
wri ' // JScript to run in the Window onload event'
wri ' }'
wri ' </SCRIPT></HEAD>'
wri '<body width="200">'
wri '<pre>'
wri '<image Src="">'
wri ' CustID Company ' continue
wri 'CheckDate Net Amount Freight Tax Invoice Total'
wri '-----------------------------------------------' continue
wri '------------------------------------------------------------'
Select (Rjs((ctxt(CustID)),5))=5,Company=40,TransDate=12, +
NetAmount=14,Freight=8,Tax=8,InvoiceTotal=12 +
from SalesData order by company
wri '</pre></body></html>'
out scr
launch hold.hta
return
