Thanks guys!
>>> [EMAIL PROTECTED]> 8/30/05 1:22 PM >>
The correct syntax for the second method doesn't use "VALUES()". I would always
use this form if I were going to exclude any columns from receiving data. It's
just safer and relies less on the SQL engine to correctly divine what it is y
"Ed Reed" <[EMAIL PROTECTED]> wrote on 08/30/2005 04:08:57 PM:
> Can anyone please tell me why this fails, I've done this type of
> thing before without a problem
>
> Insert Into tbl1 Select 10306, fld2, fld3, fld4 From tbl1 Where
fld1=8114
>
>
> tbl1 has five fields all ints with fld5 being
cting from.
Eamon Daly
- Original Message -
From: "Ed Reed" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, August 30, 2005 3:08 PM
Subject: Insert Into problem
Can anyone please tell me why this fails, I've done this type of thing
before witho
Can anyone please tell me why this fails, I've done this type of thing before
without a problem
Insert Into tbl1 Select 10306, fld2, fld3, fld4 From tbl1 Where fld1=8114
tbl1 has five fields all ints with fld5 being the autoincrement index.
I've also tried it as,
Insert Into tbl1 (fld1, f
