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 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.
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
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.
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 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
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.
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.
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.
who else is working on their PAT
@Piano-Onset damn same
hey, u still got ur completed PAT?
...
Yurr
my situation is dire 😂
Very clear. Works well for me.
wow, its the best video.
Q: how to use OOP with database?
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).
but remember delphi is a dying language and Mr long is doing an exceptional job better than most people
@@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.
so touching for an excellent video
This helped me so much thank you
Bruh
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.
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?
You only need one ADOConnection but you do need an ADOTable and DataSource for each table.
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
Have you made the connection dynamically (using code) or have you set the settings manually in the ADOTable?
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
I have problems with read. The create method fails.
Best video ever
please how to do connect button to access database in delphi , i want a dynamic login , so i can change database
thank you
Have you seen the following video I did about a log in screen - ruclips.net/video/5kqUQYiC5Sc/видео.html
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
Use the Forms OnActivate event. Click on the form, then go to the events tab and look for the Activate or OnActivate event.
When connecting the dbgrid to datasource, how do you specifiy which table you want to display ? Mines shows only one table
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.
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
Check that your database is in the correct location. Which version of Delphi are you using?
@@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
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
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.
@@MrLongITandCAT how do I put it in the debug folder?
You a G🎉
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.
Which part of the code is highlighted when you get the message?
Hello. How to link two tables through ADOQuery? Database Access.
We have a video where we interact and setup an ADOQuery. Here is the link: ruclips.net/video/uaK_FZzmXug/видео.html
Is it possible to insert the connections string in an ini file?
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.
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
Have you used the create command with your TDataSource?
14:19
I get an access violation error sir
Can you tell which part of the code it is giving the error for?
@@MrLongITandCAT it's alright sir I found out why it happened and fixed it
2024 anyone 😭
Лучше бы на компонентах понятнее
so touching for an excellent video
so touching for an excellent video