With the following code I am trying to change all records of Show field into False that matchs with to the following condition.
clientID :=5; contractNo := 10;
QuerySort.Active := False;
QuerySort.SQL.Text := 'UPDATE DEBTS SET Show=' + '''' + '''False''' + ''''
+ ' WHERE (ClientID= IntToStr(clientID))and(ContractNo=contractNo)';
clientID and contractNo are the variables into which I am giving values above.