Delphi Programming Tutorial #21 - SQL Part Three

In this guide on SQL we look at the update and delete statements

Category:

Howto & Style

Tags:

• delphi
• programming
• tutorial
• sql
• update
• delete

[samoe022]

the code for execute button pls

[codegearguru]

@samoe022 Something like (off the top of my head):

To Open a Query

Query1.Close;

Query1.SQL.Text := Memo1.Lines.Text;

Query1.Open;

To Execute a Query:

Query1.ExecSQL(Memo1.Lines.Tex­t);

[codegearguru]

Thanks, I try to keep them short but still full of good content. I still have quite a lot to cover which I should probably get around to doing at some stage.

[samoe022]

thank you so much Sir I really appreciate all this great videos that you have here in youtube, god bless you.

please put as much you can from what you know when you have time, this help us a lot.

[nomineZERO]

When did you imput the Execute button and what's the difference between them in the code?

[jw200]

Very useful. Im learning database programming in Delphi at the moment and any tutorial is very helpful.

Thanks for this.

[bosky321]

thanks...the tutorial is very helpful and is not as boring and lenghty like the other sql tutorials