gt;>Values (("56-56", 5), ("27-01", 1), ("15-02", 2));
>>
>>I've tried it with and without the outer parens.
>>
>>Thanks
>>
>>
>>
>>>>>"Adolfo Bello" <[EMAIL PROTECTED]> 12/1/2002 5:42:34 AM >
Table1 (Product, Qty)
>>Values (("56-56", 5), ("27-01", 1), ("15-02", 2));
>>
>>I've tried it with and without the outer parens.
>>
>>Thanks
>>
>>
>>
>>>>>"Adolfo Bello" <[EMAIL PROTECT
L PROTECTED]> 12/1/2002 5:42:34 AM >>>
>
> INSERT INTO your_table(fields_list) VALUES
> (record_1),(record_2),...,(record_n);
>
>
>>-Original Message-
>>From: Ed Reed [mailto:[EMAIL PROTECTED]]
>>Sent: Saturday, November 30, 2002 3:47 PM
>&g
ot;, 1), ("15-02", 2));
>
> I've tried it with and without the outer parens.
>
> Thanks
>
>
>>>>"Adolfo Bello" <[EMAIL PROTECTED]> 12/1/2002 5:42:34 AM >>>
>
> INSERT INTO your_table(fields_list) VALUES
> (record_1
;
> INSERT INTO your_table(fields_list) VALUES
> (record_1),(record_2),...,(record_n);
>
>
>>-Original Message-
>>From: Ed Reed [mailto:[EMAIL PROTECTED]]
>>Sent: Saturday, November 30, 2002 3:47 PM
>>To: [EMAIL PROTECTED]
>>Subject: Multiple Ins
ens.
Thanks
>>> "Adolfo Bello" <[EMAIL PROTECTED]> 12/1/2002 5:42:34 AM >>>
INSERT INTO your_table(fields_list) VALUES
(record_1),(record_2),...,(record_n);
> -Original Message-
> From: Ed Reed [mailto:[EMAIL PROTECTED]]
> Sent: Saturda
INSERT INTO your_table(fields_list) VALUES
(record_1),(record_2),...,(record_n);
> -Original Message-
> From: Ed Reed [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, November 30, 2002 3:47 PM
> To: [EMAIL PROTECTED]
> Subject: Multiple Inserts and updates
>
>
&g
Can anyone give me an example of how to insert and/or update multiple
records in the same table simultaneously?
I have a table with three fields; ID, PartNum, Qty. The user enters
PartNum and Qty data in an unbound grid UI. When the user hits "Save"
I'd like to build a single SQL statement from th
