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]
