Update SQL query
Posted on 2003-11-17
I'm using Delphi 5 with MS SQL and am trying to execute a update SQL query. Mostly I have been updating integer fields which has been no problem, but now I want to update a string field, which is causing me problems because of the single quotes needed in the SQL.
AdoCommand.CommandText := 'update customer set CustomerType = 'text' where rec = 99;
Obvisouly the problem here is that the 'text' must be in single quotes (or somthing similar) but also the SQL stmt must be in single quotes as well (or something similar)
However I don't know what the something similar must be.
Simple I know, but I'm really stumped as to that I should use.