Pascal and Delphi

Delphi sql delete

Please support our Pascal and Delphi advertiser: Programming Forums - DaniWeb Sister Site

•

Join Date: Oct 2006

Posts: 17

Reputation: taineechan is an unknown quantity at this point

Solved Threads: 1

taineechan taineechan is offline

Offline

Newbie Poster

Delphi sql delete

Oct 1st, 2008

Hi All

I want to delete records from a table. I'm using the following query:

 Help with Code Tags 
 Pascal and Delphi Syntax (Toggle Plain Text) 
adqdelete.active := false;
adqdelete.sql.add('delete from stalls');
adqdelete.sql.add('where stall_name =');
adqdelete.sql.add(edtDeleteStalls.Text);
adqdelete.active:=True;
adqdelete.active := false;
adqdelete.sql.add('delete from stalls');
adqdelete.sql.add('where stall_name =');
adqdelete.sql.add(edtDeleteStalls.Text);
adqdelete.active:=True;

This gives a syntax error. does anyone know what I'm doing wrong?

Thanks for your time
Tai

try{ be yourself;}
catch(you suck){be someone else;}

//always be yourself:unless you suck

•

Join Date: Sep 2008

Posts: 10

Reputation: espSquall is an unknown quantity at this point

Solved Threads: 1

espSquall

Offline

Newbie Poster

Re: Delphi sql delete

Oct 2nd, 2008

I'm pretty new to SQL but shouldn't you add a ';' at the very end of the query?

Just a thought,

Tom

•

Join Date: Apr 2008

Posts: 3

Reputation: ennis is an unknown quantity at this point

Solved Threads: 0

ennis

Offline

Newbie Poster

Re: Delphi sql delete

Oct 2nd, 2008

[QUOTE=taineechan;702787]Hi All

I want to delete records from a table. I'm using the following query:

 Help with Code Tags 
 Pascal and Delphi Syntax (Toggle Plain Text) 
adqdelete.active := false;
adqdelete.sql.add('delete from stalls');
adqdelete.sql.add('where stall_name =');
adqdelete.sql.add(edtDeleteStalls.Text);
adqdelete.active:=True;
adqdelete.active := false;
adqdelete.sql.add('delete from stalls');
adqdelete.sql.add('where stall_name =');
adqdelete.sql.add(edtDeleteStalls.Text);
adqdelete.active:=True;

adqdelete.active := false;
adqdelete.sql.clear;
adqdelete.sql.add('delete from stalls where stall_name = ' + quotedStr(edtDeleteStalls.Text));
adqdelete.active:=True;