[RBG7-L] - RE: PRNSETUP

[Javier Valencia]

Ted: >>>>> SET VAR vprintername TEXT ='Kyocera Mita FS-9500DN KX' SET VAR tray1 TEXT='Multi-Purpose Feeder' PRINT nrecapl1 WHERE adv_no  = .vadv OPTION printer|DUPLEX HORIZONTAL|tray .tray1|printer_name .vprintername   SET VAR tray2 TEXT ='Cassette 1' LBLPRINT labelsforadv WHERE adv_no  = .vadv  ORDER BY iss_yy DESC, iss_mm DESC, rs_no ASC,zp_code ASC, zp_4 ASC OPTION printer|duplex simplex|tray .tray2|printer_name .vprintername <<<<< You need to use ampersand variables rather that dotted variables where you want to use the literal value and the variable is not on the right side of an operator.   SET VAR vprintername TEXT ='Kyocera Mita FS-9500DN KX' SET VAR tray1 TEXT='Multi-Purpose Feeder' PRINT nrecapl1 WHERE adv_no  = .vadv OPTION printer|DUPLEX HORIZONTAL|tray &tray1|printer_name &vprintername   SET VAR tray2 TEXT ='Cassette 1' LBLPRINT labelsforadv WHERE adv_no  = .vadv  ORDER BY iss_yy DESC, iss_mm DESC, rs_no ASC,zp_code ASC, zp_4 ASC OPTION printer|duplex simplex|tray &tray2|printer_name &vprintername   Hopefully this will help with your problem. Javier,   Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln, Suite #14 Olathe, Kansas 66062-4578 Office (913)829-0888 Fax (913)649-2904 Cell (913)915-3137 ================================================ Attention: The information contained in this message and or attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material.  Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from all system and destroy all copies. ======================================================   -----Original Message----- From: rbg7-l@rbase.com [mailto:[EMAIL PROTECTED]On Behalf Of Ted Wolfley Sent: Thursday, August 11, 2005 8:50 AM To: RBG7-L Mailing List Subject: [RBG7-L] - PRNSETUP   Hi,   I am having a problem getting our printer to work correctly with a server.  The command prints a duplex cover sheet, then simplex label sheets. The following commands work correctly on a workstation but not on the server. Both have the same version of Rbase 7.1 and the printer  setup is the same, which is thru a tcp/ip port.     SET VAR vprintername TEXT ='Kyocera Mita FS-9500DN KX' SET VAR tray1 TEXT='Multi-Purpose Feeder' PRINT nrecapl1 WHERE adv_no  = .vadv OPTION printer|DUPLEX HORIZONTAL|tray .tray1|printer_name .vprintername   SET VAR tray2 TEXT ='Cassette 1' LBLPRINT labelsforadv WHERE adv_no  = .vadv  ORDER BY iss_yy DESC, iss_mm DESC, rs_no ASC,zp_code ASC, zp_4 ASC OPTION printer|duplex simplex|tray .tray2|printer_name .vprintername     Is there a setting that I am missing?     Ted Wolfley Database/Internet Programmer The Ogden Group of Rochester 5637  West Henrietta Road West Henrietta, NY 14586 phone: (585) 321 1060 x23 fax: (585) 321 0043 [EMAIL PROTECTED] www.ogdengroup.com