Delphi Programming Tutorial #10 - SQL Part One

This is the first part in a multipart series on using SQL.

Category:

Howto & Style

Tags:

• SQL
• delphi
• training
• programming
• structured
• query
• language
• tutorial

[KanouCheung]

Thanks for the video! taught me alot about SQL. Can I ask, is the code:

Query1.SQL.Text

responsible for storing that table? Thanks!

[codegearguru]

Query1.SQL is the TStringList responsible for storing the query - i.e. the text "Select * from SomeTable".

[shararehf]

Thank you so much !

[codegearguru]

You're welcome. There are bunch of other videos on SQL, and there are others I need to do (if I can find the motivation).

[MAGStation]

Fastest Talker ever.

[PierreBatka]

Really useful. I loved it. But please, please speak just a little slower. It is still understandable though, but still, no need to rush. :-)

[showtimeoooo]

TO FASTTTTTTTTTTTTTTTTTTTTTTTTTTT­TTTTTTTTTTTTTTT

[kiwiavi]

I'm not quite there yet. I can't edit the dbGrid data. On a dblClick of the dbGrid form, I want to edit the data in new form. Do I need to link the displayed data in the query back to the original table for editing in the new form ?

[kiwiavi]

Thanks Alister. Diaries have never worked for me and the New Years Resolution was to make something that worked. Your video has helped me get my displayed data working correctly. What initially caught me was that I would have assumed that the tquery was linked to a table within the DB, but I now see it is not. All the best for 2011. Cheers Wallace.

[SenorHrvoje]

huh.. you need to talk alot more if you want to make tutorial, other is I guess ok... I couldn't follow you

[khireddinerca]

merciiiiiiiiii very mercy :)

[xabyka]

i want good resolution

[Q3o5]

'active' must be true in the TQuery

[surjitjazz]

hi i have problem with dbgrid it does not show in when i run

[codegearguru]

That would be Delphi, at the time it was probably Delphi 2007, I've just started using Delphi 2010 this week - and it rocks!