Find all the records in the table and change the text

[DeddyH]

I would prefer to use a query instead of a table and change the records by SQL.

Delphi-Quellcode:

Query.Close;
Query.SQL.Text := 'UPDATE Tablename SET Permission = :new WHERE Permission = :old';
Query.ParamByName('new').Value := Edit2.Text;
Query.ParamByName('old').Value := Edit1.Text;
Query.ExecSQL;