Home » Developer & Programmer » Forms » Show Printer List
Show Printer List [message #243392] Thu, 07 June 2007 03:33 Go to next message
skkazmi
Messages: 44
Registered: April 2006
Member
Hello All,

I am using Oracle Forms 6i,
I want to invoke all installed printer list in LOV.

if its posible then pls gives detail about.

Regards,
Khurram Kazmi.
Re: Show Printer List [message #244788 is a reply to message #243392] Thu, 14 June 2007 02:20 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Out of curiosity, what are you going to do with this list?

David
Re: Show Printer List [message #245143 is a reply to message #244788] Fri, 15 June 2007 05:10 Go to previous messageGo to next message
skkazmi
Messages: 44
Registered: April 2006
Member
Hi,

Thks 4 reply. my task is to populate the printer list before print. because my report is sort of type bar-code. user can select the printer before print.

Khurram Kazmi
Re: Show Printer List [message #245496 is a reply to message #245143] Sun, 17 June 2007 21:22 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Are you running Forms 6i client/server or 3-tier? Are you trying to print on the local printer, a Windows network printer, or a Unix network printer?

David
Re: Show Printer List [message #245664 is a reply to message #245496] Mon, 18 June 2007 06:17 Go to previous messageGo to next message
skkazmi
Messages: 44
Registered: April 2006
Member
i m use oracle form 6i client/server
n show all printer list which are installed in a PC.
Network Printer,or
Local Printer.

Khurram Kazmi
Re: Show Printer List [message #247173 is a reply to message #245664] Sun, 24 June 2007 23:59 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
I never like answering this question. Printing sux!

Okay, once you have this printer name are you going to pass it to Oracle Reportwriter to use for its output? Are you oging to run a database procedure to do the printing? Is the server a Windows machine or Unix? Because if its Unix then the printer list is different to the Windows printer list.

If you want to print a bar code on 'prt' then just have a button whic hsays 'Print barcode' and assume that it is on 'prt'. If nothing is there then they won't get a barcode printed.

David

Have a look at "win_api_dialog.select_printer problem in 10G"
https://metalink.oracle.com/metalink/plsql/f?p=200:27:8311904113866285087::::p27_id,p27_show_header,p27_show_help:639358.999,1,1
refers to
https://metalink.oracle.com/metalink/plsql/showdoc?db=NOT&id=300844.1

You may be able to use 'd2kwutil' to do something similar.

Re: Show Printer List [message #247515 is a reply to message #243392] Tue, 26 June 2007 03:09 Go to previous message
hemavb
Messages: 103
Registered: May 2007
Location: Dubai , UAE
Senior Member
attach the d2kwutil lib to your form. From there use the win_api_dialog.select_printer function.

If is NOT an LOV but the windows dialog for selecting a pprinter that you normally get when you click the Print button in the windows application.
It returns the name of the printer, path included if it is a shared printer.

Pass this to the desname parameter for the report and the print will come to the selected printer.

Hemavb
Previous Topic: multiple row relationship
Next Topic: Login form (was:"very" descriptive URGENT etc.) (merged)
Goto Forum:
  


Current Time: Mon Dec 05 11:02:31 CST 2016

Total time taken to generate the page: 0.04849 seconds