How to do an SQL SELECT in Delphi

This explains how to use an SQL Select statement in Delphi by using the ADOQuery component. #MrLongEducation #Programming #SQL
SQL Video Series
SELECT Statements
Basics Part 1 - • SQL Basics - SELECT qu...
Basics Part 2 - • SQL Basics - SELECT qu...
Basics Part 3 - • SQL Basics - SELECT qu...
Basics Part 4 - • SQL Basics - SELECT qu...
Advanced Part 1 - • SQL Advanced - SELECT ...
Advanced Part 2 - • SQL Advanced - SELECT ...
Advanced Part 3 - • SQL Advanced - SELECT ...
Advanced Part 4 - • SQL Advanced - SELECT ...
Advanced Part 5 - • SQL Insert
SELECT in Delphi - • How to do an SQL SELEC...
INSERT Statement - • SQL Insert
UPDATE Statement - • SQL Update
DELETE Statement - • SQL Delete
INSERT in Delphi - • How to do an SQL INSER...
UPDATE in Delphi - • How to do an SQL UPDAT...
DELETE in Delphi - • How to do an SQL DELET...

[@Connor-ec5vs]

You are the reason I will pass my exam tomorrow

[@jameswheeler9945]

Keep doing what yer doing, man. Helping a lot of people!

[@memelordnord8861]

you make IT at school so much easier. Keep it up

[@mysticware3496]

You my man , have helped in such a way that i think you deserve an award.

[@jackybrancken6313]

Thank you thank you thank you! I thought I was going to fail my test on this on Monday but this helped me understand everything soooooo much better!!

[@卡机不]

Thank you so much!! You saved my day man!

[@clappedcorsac1024]

i wish my IT teacher was as good at explsining as you bro

[@Damz_19]

Thank you ,this video helped me so much❤

[@NqobileNxumalo-wq3wn]

Thank you Mr long........!

[@nathannaidoo8524]

I finally understand. Thanks so much

[@dedicationmotivation8408]

Beyond helpful🙏

[@rakhirathore4954]

Thank you! its very helpful! How do I extract data from dbgrid to put it on a dbText ? I set the data source, but DateField says missing SQL

[@ameeraakmalia3260]

hi. i followed your tutorial, but when i run the application and click the find button, there is no data displayed on the dbgrid. do you have any idea how to fix this? thanks.

[@travisfuller9393]

The DBGrid should have a property in the object inspector (Data Source) which should be set to the Data Source on the data module which has been connected to the query (with the SQL)

[@darvazafitness972]

but wat if after you do the above and its give you a parameter error

[@wtfwtfisaidwtf]

Check the spelling of your field name, it should be the same as your field name in access

[@neilljansenvanvuuren9025]

Great video, thank you very much. Unfortunately my delpi states dmName is an undeclared identifier but it does recognise dmName_u?

[@MrLongITandCAT]

Did you give your data module the name. CLick on the Data Module then go to the object inspector and change the name to dmName

[@Toturials]

Hi, I have a question, for example I create an application on my Pc, Pc name might be “Dell” this ado connection will add this pc name in connection string. And now if I want to run this application on other computer, I need source code, and again I have to establish ado connection according to new pc name. is it possible that it works for any pc without making any changes? Other way of doing this with code, but then problem is you cannot see any data in design time like you are seen in tables all the column and data.

[@paulcross]

THANK YOU.

[@anasbr3586]

the select * is working, but not with the where ? error ( invalid column name : "name from edit")

[@MrLongITandCAT]

Can show us the code you used?

[@anasbr3586]

@@MrLongITandCAT adoquery1.SQL.Add('Select * from client where Numero = "CL001" ');

[@anasbr3586]

@@MrLongITandCAT adoquery1.SQL.Add('Select * from dbo.client where dbo.client.id = 1'); this one is working, so using integer works fine, but using string is not

[@MrLongITandCAT]

@@anasbr3586 The one you gave that is working is using dbo client but the one that isn't working has no dbo. Does that make a difference?

[@anasbr3586]

@@MrLongITandCAT thank you for replying, yes i tried that, the same error message, the same query work fine in sql server, when i use "text" in sql server the same error message appears so i guess that the problem must be the quotation marks!

[@rihannasami8990]

thank you

[@mehmetyasin3686]

which menu?? (select,insert,update,delete)

[@robertjuniorinnocentkhuzwa1276]

Hey there Mr Long, I hope you're good. Can I please have the datafiles of this project please.

[@nikolaosspyrou5660]

Self Created DataModule?! What happens on larger scale projects? If for instance, you have 50 DataModules?? Will you be filling up memory with objects you might not even need on runtime? And why clearing the TStrings collection of TADOQuery object? var _dmMusic : TdmMusic := TdmMusic.Create(self); var dsQryMusicDataSource : TDataSource := TDataSource.Create(self); dsQryMusicDataSource.DataSet := _dmMusic.qryMusic; with _dmMusic do Begin if qryMusic.Active then qryMusic.Close; qryMusic.SQL.Text := 'Select * from Owners'; yourDBGrid.DataSource := dsQryMusicDataSource; qryMusic.Open; End; That's the code you seek for,, without having self-created DataModules and objects in your entire project with significantly less memory footprint.

[@amaara7164]

Cn you do a video on the pat

[@MrLongITandCAT]

Hi. We have a whole playlist of PAT TIPS that you can use (see link below). More TIP videos will be added this year. Go look at: kzbin.info/www/bejne/a5zUhoSPnqhoicU

[@amaara7164]

@@MrLongITandCAT okay thanks please can you add for this year

[@MrLongITandCAT]

@@amaara7164 Definitely. It is on the planned schedule for this year.

[@trisanchetty6031]

What component is the database grid in?

[@MrLongITandCAT]

It's under Data Controls.

[@belgacemdliouah4267]

Merci

[@vvs_kade6825]

im connecting my Query but it is coming up with the error missing sql property

[@MrLongITandCAT]

You must have some text in the SQL property for the SQL to run when the ado query is active or open. It's like changing a lightbulb. First switch it off, then change it, then switch it on. So for the ado query you first make it active := false ; //should be made false by default then you enter your SQL statement into the ado query's SQL property adoquery.SQL.Text := 'SELECT....' ; Then you "switch the query on" by setting active property to true. If you SQL is correct then the query will run.

[@vvs_kade6825]

Mr Long IT & CAT Thank you sm

[@8legs_gaming510]

nice but upgrade you'r mic

[@MrLongITandCAT]

Thanks. We have.

[@nicholasjvr250]

STOUTTTT

[@tristanbookhan9956]

hello

[@paulcross]

Just want to say THANK YOU．

[@paranoyakepizot3740]

DataBase Firebird SQL ; if ch_AramaOpsiyon.Checked = False then sAra := QuotedStr ( UpperCase ( eAra.Text+'%') ) else sAra := QuotedStr ( UpperCase ( '%'+eAra.Text+'%') ); with dm.qryStokBaslik do begin Close; SQL.Clear; SQL.Add( 'SELECT * FROM T_CARI'); SQL.Add( 'WHERE CARI_ADI LIKE '+ sAra +' ORDER BY ...'); Open; end;