Ok... I understand. ----- Original Message ----- From: "ArminThoma" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Thursday, June 23, 2005 11:05 AM Subject: [RBG7-L] - Re: PrinterNames in a table
> Albert, Sami, Mike > > thanks for your help. It does what I want. > > Mike, there are LabelPrinter, ReceitPrinter, InkJetPrinter at the > POS-Workstation. So different reports are printed on different printers. I > dont want the user has to choose printers before printing. Once after the > application is installed he has to define the printers for the different > tasks and that is done by some ComboBoxes. > > Armin > > > > > ----- Original Message ----- > From: "Albert Berry" <[EMAIL PROTECTED]> > To: "RBG7-L Mailing List" <[email protected]> > Sent: Wednesday, June 22, 2005 11:45 PM > Subject: [RBG7-L] - Re: PrinterNames in a table > > >>I misread your original posting, sorry. You need to put the values in one by >>one. You can do this >> in a short command file using a loop to parse out the printer names. >> >> -- Assumes that vPriList is already populated, such as >> 'Printer1,Printer2,Printer3' >> SET VAR vPriList TEXT = (CVAL('Printers')) >> SET VAR vPrinter TEXT >> SET VAR vCount INTEGER = (ITEMCNT(.vPriList)) >> WHILE vCount > 0 THEN >> SET VAR vPrinter = (SSUB(.vPriList,.vCount)) >> INSERT INTO AllPrinters (PriNames) VALUES (.vPrinter) >> SET VAR vCount = (.vCount - 1) >> ENDWHILE >> SELECT * FROM AllPrinters >> RETURN >> >> >> --- ArminThoma <[EMAIL PROTECTED]> wrote: >> >>> Albert >>> INSERT INTO AllPrinters (PriNames) VALUES (&vPriList) >>> brings -ERROR- Columne or variable ... not found >>> -ERROR- Syntax is incorrect for the command INSERT >>> >>> Any other idea? >>> Armin >>> >>> >>> ----- Original Message ----- >>> From: "Albert Berry" <[EMAIL PROTECTED]> >>> To: "RBG7-L Mailing List" <[email protected]> >>> Sent: Wednesday, June 22, 2005 8:43 PM >>> Subject: [RBG7-L] - Re: PrinterNames in a table >>> >>> >>> > Try the following. Note the spaces and braces <G> >>> > >>> > INSERT INTO ..... VALUES ( &vPriList ) >>> > >>> > --- ArminThoma <[EMAIL PROTECTED]> wrote: >>> > >>> >> Hi al >>> >> >>> >> I want to show all the printernames in a DB ComboBox. >>> >> With (CVAL('printers')) I can build the variable vPriList with >>> >> (printer1, >>> >> printer2, ...). >>> >> >>> >> What's the best way to put these printernames into the table AllPrinters >>> >> with the column >>> >> PriNames? >>> >> >>> >> I tried INSERT INTO ..... VALUES &vPriList. But no success. >>> >> >>> >> Could anybody help? >>> >> >>> >> Armin >>> > >>> > >>> > Albert Berry >>> > Management Consultant >>> > RR2 - 1252 Ponderosa Drive >>> > Sparwood BC, V0B 2G2 >>> > Canada >>> > (250) 425-5806 >>> > (250) 425-7259 >>> > (708) 575-3952 (fax) >>> > [EMAIL PROTECTED] >>> > >>> > >>> >>> >> >> >> Albert Berry >> Management Consultant >> RR2 - 1252 Ponderosa Drive >> Sparwood BC, V0B 2G2 >> Canada >> (250) 425-5806 >> (250) 425-7259 >> (708) 575-3952 (fax) >> [EMAIL PROTECTED] >> >> >
