delete record in delphi with fdqury when this value of record

[ABDELLAH GADi 0]

Help me to fix this problem to delete record in delphi with fdqury when this value of record is choosed by me with edit.text or dbedit.text i try like this but is not working so

fdquery.SQL.Text := 'delete * FROM MyTable column_name =:KEY1 ';
fdquery.ParamByName('KEY1').AsString = 'dbedit.text';
fdquery.Open;

thank you 

[Lajos Juhász 293]

Quote

fdquery.SQL.Text := 'delete FROM MyTable WHERE column_name =:KEY1 ';
fdquery.ParamByName('KEY1').AsString = dbedit1.text;
fdquery.ExecSQL;

 

Edited February 27, 2022 by Lajos Juhász

[Guest]

FDQ.ExecSQL(  'sqlExpression...', [params] );

 

Edited February 27, 2022 by Guest