I'm now mostly certain the SET PRINTER TO will empty the print queue buffer as I recall years ago we had issue with printer output of REPOR FORM hanging up in the print queue forever after the report had been finished and then it printed immediately after we added the SEST PRINTER TO command...
Sorry, the testing is still in progress and very slow due to the fact I'm working from remote and have to work with people in the office, where the printer is located, who are not familiar with VFP printing so I'm only getting test results piece by piece and therefore wasn't able to report back...
Chris
We don't use linefeed,formfeed codes for printing anymore; only when we are building HTML or EDI text files.
We use ??? and ?? only for sending font settings Esc codes to Epson and we did not want the code to change print positions.
And the reason for using ??? is we are not able to put...
Esc codes are used here primarily for printer font selection purpose for Epson LQ-590 dot-matrix printer (unfortunately we are still searching for laser alternatives for multi-part paper apps, or paperless options, but still, people need that piece of paper). The build-in Set Printer Font...
I'm familiar with start/stop procedures of spooler under Windows Services.
Here it seems I need to use Generic/Text as driver (vs Epson printer driver) and disable print spool; that's what I did by selecting 'Print directly to printer' instead of 'Spool print documents' under printer property...
That did it.
Changed the driver from Epson to Generic/Text and the Esc code went through and reconfigured the fonts.
Thanks everyone.
One note: even I set Widows printer property to no spool (print direct), the print job still went to the print queue and won't go away until multiple 'set printer...
Hello colleagues,
https://www.tek-tips.com/threads/sending-printer-command-from-vfp.76448/
Above is an old thread that deals with exactly the same issue as I'm having now.
My code:
mpname = GETPRINTER()
SET PRINTER TO NAME &mpname
SET DEVICE TO print
SET PRINTER on
??? chr(27) + "x" + "0" &&...
You know you can have grand totals at the end too, correct ?
Just in case, the grand totals can be coded in group footer, outside and after detail band, in similar coding to detail band.
If the totals are for each detail record then you'll have to use (tarimarbr + tpormarbr + tranmarbr + servmarbr), which I assume are data fields, instead of TotalMarBR.
To do that, insert a field type in detail band after 'Totals:' and use the expression to define the total you wanted:
Hello,
Our main concern is hacker.
I understand there are many access control mechanisms within MS SQL to control user access.
Bur what if a hacker somehow figured out the sa credentials, or otherwise gained access to the file system of the server from the public web portal on the Internet ...
Comments well noted. This setup of ours has been working for over a decade and has served our purpose well. Yes it does come with limitations with our customization. But so far so good. And the new SQL logic, after initial testing, seems to be doable; that was my concern when I posted this...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.