Databases in Delphi - Connecting to a database using code

[@zanderv.l5607]

who else is working on their PAT

[@blakehenery9184]

@Piano-Onset damn same

[@mubata1401]

hey, u still got ur completed PAT?

[@Batzuki]

...

[@polobeast9647]

Yurr

[@Prettyboi_pete]

my situation is dire 😂

[@staceyadams9954]

Nice and clear. I like how you explain why you do what you do. I only wish you used consistent, recommended code indentation practices. It makes code more readable, and given that you are influencing a whole new generation of Delphi coders, it would be nice for them to start off using generally accepted code formatting standards (e.g., contents within begin/end code blocks should be indented).

[@KingSimba2077]

but remember delphi is a dying language and Mr long is doing an exceptional job better than most people

[@staceyadams9954]

@@KingSimba2077 I don't disagree about the exceptional job (no one I can compare him to), but the more exceptional the job, the more someone's reach might be and, therefore, the more potential they have to influence the next generation in good and bad ways. The part about Delphi being a "dying language" is unfortunate. Such an amazing, flexible tool.

[@michaeldaniels5004]

wow, its the best video. Q: how to use OOP with database?

[@MikeWeideli]

Very clear. Works well for me.

[@lethabodichaba6250]

This helped me so much thank you

[@natidaschoolboy]

Bruh

[@thangbui7169]

so touching for an excellent video

[@DrippyKlifestyle]

Hi Mr Long, i did everything as you said in the video but it gives me an access violation error when i run the program. Please help.

[@jordanyusuf4]

Best video ever

[@KalaiVorneKisten-vw9fz]

Hello sir, I wanted to ask, do I have have multiple data sources to go with each table or can I use one datasource for all my tables?

[@MrLongITandCAT]

You only need one ADOConnection but you do need an ADOTable and DataSource for each table.

[@theyluvvsande5178]

Hii Mr long i followed every instruction on this video but whenever i tried running it it told me that it cannot find the program but i did put it on the host application

[@stevenpaulsen5975]

himister long my db is not being picked up when its in the same folder as my project it keeps looking for it in documents please help

[@MrLongITandCAT]

Have you made the connection dynamically (using code) or have you set the settings manually in the ADOTable?

[@sevketiskender3229]

Hello. How to link two tables through ADOQuery? Database Access.

[@MrLongITandCAT]

We have a video where we interact and setup an ADOQuery. Here is the link: kzbin.info/www/bejne/q5KukHmQr9KLq8k

[@hipinq1614]

Sir I'm unable to find the 'OnShow' event by the event panel, what should i do to be able to connect the dbgrid to the datasource

[@MrLongITandCAT]

Use the Forms OnActivate event. Click on the form, then go to the events tab and look for the Activate or OnActivate event.

[@mutombokabau1390]

You a G🎉

[@ebrahimismail4698]

When connecting the dbgrid to datasource, how do you specifiy which table you want to display ? Mines shows only one table

[@MrLongITandCAT]

Your adoTable component has a tablename property that is set to the table name. If you want to change the dbgrid to another table, then first close the table (adoTable.Close) then reset adoTable table name property to new table then then open the table (adoTable.Open) Another option is to do the whole process (except adoConnection part) for the second table and have it displayed in another dbGrid.

[@donartista1648]

please how to do connect button to access database in delphi , i want a dynamic login , so i can change database thank you

[@MrLongITandCAT]

Have you seen the following video I did about a log in screen - kzbin.info/www/bejne/a5zUhoSPnqhoicU

[@mateodebeer3251]

Hi mister long I have connected my date base dynamically exactly as you did in the video but I am getting a Access violation adress error if you could please help.

[@MrLongITandCAT]

Which part of the code is highlighted when you get the message?

[@jckson3059]

Hey Mr long, I did everything from this video but when I try to run it, it tells me that it could not find the file

[@MrLongITandCAT]

Are you sure your database is in the correct folder. If you are using Delphi 10.4 or Delphi 11 then make sure the database is in the debug folder of your project folder.

[@jckson3059]

@@MrLongITandCAT how do I put it in the debug folder?

[@emcicco]

Is it possible to insert the connections string in an ini file?

[@Zipher7]

Yes, just load the INI file before opening the connection and place it within the connectionstring := ini.readstring('adostring'); or how ever its called sorry forgot.

[@kaelinkesavjee2298]

Hello mr long i have connected the database dynamically but im getting an Access violation adress error. The error is this line of code 'tblCD.connction := conCD;' thats the line of code it shows is the issuse when i run it through the debug, please help. Thank you

[@MrLongITandCAT]

Check that your database is in the correct location. Which version of Delphi are you using?

[@kaelinkesavjee2298]

@@MrLongITandCAT Hello mr long i have figured out what the issue is. i didnt add a owner to the second table that i created. Thank you for your help and guided video as it was very helpful

[@jaydenwilliams6408]

Im getting a 'argument out of range' error. I know the problem is with the datasource not showing up but i dont know how to correct it

[@MrLongITandCAT]

Have you used the create command with your TDataSource?

[@Holy777-j7i]

2024 anyone 😭

[@confuzzledrage9648]

14:19

[@fleqq1827]

I get an access violation error sir

[@MrLongITandCAT]

Can you tell which part of the code it is giving the error for?

[@fleqq1827]

@@MrLongITandCAT it's alright sir I found out why it happened and fixed it

[@Дубровский-ч4с]

Лучше бы на компонентах понятнее

[@nguyenquangminh3464]

so touching for an excellent video

[@namlengoc9844]

so touching for an excellent video