Append Query Failing

[Guest]

Hi,
I have a AppendQuery as "Insert into Table1(Col1,Col2,Col3,Col4) Select
15,Col2,Col3,Col4 from Table1 where Col1 = 1;"
Consider this table already has rows as
1 5 6 7
1 5 7 8

I am using this query to replicate the whole set of rows with the change
in first feild alone as

15 5 6 7
15 5 7 8

Added to the existing table using a single query.

When i execute this query in C# it is throwing an exception "Should have
an updateable Query".

Can anybody help me out to solve this issue?

Thanks in advance.

- Vignesh.

 

[Siva M]

Check if this can help: http://forums.asp.net/121589/ShowPost.aspx

Hi,
I have a AppendQuery as "Insert into Table1(Col1,Col2,Col3,Col4) Select
15,Col2,Col3,Col4 from Table1 where Col1 = 1;"
Consider this table already has rows as
1 5 6 7
1 5 7 8

I am using this query to replicate the whole set of rows with the change
in first feild alone as

15 5 6 7
15 5 7 8

Added to the existing table using a single query.

When i execute this query in C# it is throwing an exception "Should have
an updateable Query".

Can anybody help me out to solve this issue?

Thanks in advance.

- Vignesh.