G
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.
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.