Loading

What's wrong with this SQL statement| Thanks

Anthony Clarke

Hi,

Can you tell me whats wrong in this statement please.

Its an SQL string statement. It does not error but it does not update the status field either.
string state3 = "UPDATE CCDelegation Set Status = 'In Progress' WHERE UniqueIden = '" + textBox4.Text + "'";

Thanks
Anthony

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Subhendu De16y ago
Accepted answer
First check, do you have records for this using following query

Select * From CCDelegation where UniqueIden =

The posted query is correct.

Thanks.....
0
Subhendu De16y ago
Oooopsssssssss... Bad luck :-)
0
Anthony Clarke16y ago
Hi Subhendu,
It was my fault, i left off my sqlcommand.executenonquery()

Thanks
Anthony
0