Jump to content
Sign in to follow this  
ABDELLAH GADi

delete record in delphi with fdqury when this value of record

Recommended Posts

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 

Share this post


Link to post
Quote

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

 

Edited by Lajos Juhász

Share this post


Link to post
Guest

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

 

image.thumb.png.cf14cf97474818facfafbf9bf8a05d16.png

Edited by Guest

Share this post


Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×