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]
