Board index » delphi » Paradox - local SQL problem with insert

Paradox - local SQL problem with insert

Hi there,

i bumped into a strange SQL problem, using the dbe on paradox.

The following query results in the error "Capability not supported"
which i do not understand.

insert into my_table
(id,prev_id,name)
select cast(22 as integer), cast(9 as integer),name
from my_table where id = 8

When i query only the select part, it performs fine.
Can anybody shed a light on this?
(Has it something to do that it uses the same table for both the source
as destiny-data?

Thanks in advance,

Oscar

 

Re:Paradox - local SQL problem with insert


Hi there,

i bumped into a strange SQL problem, using the dbe on paradox.

The following query results in the error "Capability not supported"
which i do not understand.

insert into my_table
(id,prev_id,name)
select cast(22 as integer), cast(9 as integer),name
from my_table where id = 8

When i query only the select part, it performs fine.
Can anybody shed a light on this?
(Has it something to do that it uses the same table for both the source
as destiny-data?

Thanks in advance,

Oscar

Re:Paradox - local SQL problem with insert


This should work, unless the id field is an autonumber field...

Quote
"Oscar Schoof" <o...@xs4all.nl> wrote in message

news:3B97CD86.C1505860@xs4all.nl...
Quote
> Hi there,

> i bumped into a strange SQL problem, using the dbe on paradox.

> The following query results in the error "Capability not supported"
> which i do not understand.

> insert into my_table
> (id,prev_id,name)
> select cast(22 as integer), cast(9 as integer),name
> from my_table where id = 8

> When i query only the select part, it performs fine.
> Can anybody shed a light on this?
> (Has it something to do that it uses the same table for both the source
> as destiny-data?

> Thanks in advance,

> Oscar

Other Threads