Hi all,

I have a typical problem of ADOquery not updating the STRING DATAFIELD,
When iam try to update a Integer data type it gets updated,

Here is my code

qry.sql.clear;
qry.SQL.Add('UPDATE TEST set testdata =aram1 where testvalue=aram2');
qry.Parameters[0].Value :=''''+edit1.text+'''';
qry.Parameters[1].Value :=45;
qry.ExecSQL;

here iam trying to update testdata with the value of Edit1.text, iam unable to do this updation.

Please Let me Know where iam going wrong, it is compiling and query also executing but it is not updating.

Regards

Balu