I am total new in Delphi. I have read some books about creating applications using simple VCL components.
I want to create a database app (using TDBGrid ?) form scratch. I downloaded Delphi 12.
How can I make DBGrid work like Excel ?
I want the user to enter the data in the grid and then on another form if she/he search for something the program should return a result from a record file.
If she/he close the app and opens it again she/he could see that the machines she/he entered are there.
All the videos, tutorials, books are assuming that there is a database file created in Microsoft Access or something like that. I don't want that. I want the user to create and manipulate the data by using my app only.
Is the solution a .dat file ?
Example:
Name | Power (kW) | Manufacturer | Year of installation
Machine 1 | 5 | Apple | 2015
Machine 2 | 3 | Seagate | 2019
Machine 3 | 2 | Microsoft | 2022
Machine 4 | 3 | Apple | 2018
Machine 5 | 1 | Seagate | 2019
Machine 6 | 3 | Apple | 2023
To read data in another form i want the user to ask for something (example: Machinery installed after 2021) and to display it in another table.
Name | Power (kW) | Manufacturer | Year of installation
Machine 3 | 2 | Microsoft | 2022
Machine 6 | 3 | Apple | 2023
Finally, are there any books I can read about databases in Delphi, without using 3d party software like Microsoft Access ?