Mark,
The other bit of my message said that you can't insert back into the same
table - because of, I assume, the scenario where you could get an infinite
loop. I should have made that more clear.
You CAN however insert into a second table - then put THAT back into the
first one.
I assume you are trying to insert back into the same table, you are
selecting from, in one step - it might have to be done programatically - or
via a temp table in two steps.
Max
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Mark Derricutt
Sent: Friday, 19 March 1999 10:26
To: Multiple recipients of list delphi
Subject: Re: [DUG]: SQL Query...
Max Renshaw-Fox wrote:
> a table - you can imagine a scenario where, without a WHERE clause - as
>is the case with the SQL below the insert becomes an infinite loop.
I just tried adding a WHERE clause but I still get capability not
supported, and also an additional error of "table does not exist:
errorins.db" ...
You may be able to suggest a different solution, I have a series of
tables that have lots of data mapped to a configuration, I wish to
"duplicate" this data with a new configuration id, so:
0, "fish", "red"
0, "cat", "brown"
becomes
0, "fish", "red"
0, "cat", "brown"
1, "fish", "red"
1, "cat", "brown"
I was hoping the INSERT INTO and the SELECT would work, but it's not
looking good (unless I'm still missing something blindingly obvious).
Mark
--
Mark Derricutt | Chalice of Blood
Software Developer | New Zealand Christian Music News
Auckland, New Zealand | http://www.chalice.gen.nz
[EMAIL PROTECTED] | UIN: 1934853
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz