Backslash in Sql

[sandeep_c24]

I am trying to execute the following command in TZQuery

Code: Select all

update TableA set FieldA = 'a\s' where FieldID = '5'

but the record in database is not updated.

If I get all the records in this table and then edit it in TDBGrid then the record is updated.

Is this a bug or am I doing something wrong?

Regards

Sandeep