Databases in Delphi - Connecting an ADOQuery using code

In a previous video (for Grade 11 IT) we explained how to connect to a database from the Delphi environment using an TADOTable component. However in Grade 12 if you want to make use of SQL statements, you will also need to use the TADOQuery component. This video shows you how to add the TADOQuery, dynamically by using code, so that you can interact with a database via SQL statements. This video will help Grade 12's particularly, with their Information Technology Practical Assessment Task (PAT).

Previous video:
#MrLongEducation​ #Programming​ #Databases

[BaneleGina]

Thanks! 🤟🏻 It is now working even though I created a function that creates the datasource and the adoquery dynamically and then executes the query. So it works for any query

[spacedout]

The timing on this video couldn't be better for me and my IT PAT

[m.c.]

"Thank you Mr Long" - We all say in unison

[SayeshenGovender]

Hi Mr Long, could you make a video on how to implement a bar graph in Delphi using Databases and the TChart component (with code). I'm having problems with it.

[joelarchary]

Hey im receiving and access violation despite using this exact code. Any ideas?

[Officialhamido]

Mr long education i have a question, and i hope you will be able to answer it, i have connected my database to adotable and used Master source so i can link between the two of tables but the problem is when i try and use filtering inside Edit component or searchbox, it gives me the same error, the meaning of the error is i can't use filtering on detailed tables, so i figured I'd use adoquery instead and does the filtering but i don't know how to do the master source between 2 ado query, that's the question, thank you for your time❤

[victornkgweng]

How about you drop another video on how to connect database using code without using data module