Topic: a question
1- Can the program create a new, empty database?
2- How do delete all data in the table grid at once?
1 2024-09-02 11:17:08 (edited by mouasomar 2024-09-02 11:17:51)
- Destiny
- Member
- Offline
Re: a question
Find on the forum
Post's attachments
Delete all TableGrid rows.zip 571.88 kb, 156 downloads since 2024-09-02
Destiny
3 2024-09-02 12:16:11 (edited by v_pozidis 2024-09-02 12:16:26)
Re: a question
Desteny has an excellent example, which is by script . You can do it also by delete the sqlite.db file and the next time when you run your program it will automatically create an empty database file (a new sqlite.db)
- jean.brezhonek
- Member
- Offline
Re: a question
Hello mouasomar
For your first question, MVD allows you to create an empty table
1 - Go to the Database TAbles tab and click New Database. You give it a name
2 - From the window that appears you create the different fields by choosing the type. If you choose a bad type, when running your project an error message will alert you.
On the Internet -> Delphi, find out especially about the differences between Integer, Real, Boolean and Currency
3 - RelationShip allows you to put two or more tables in relation. Interesting in queries.
4 - A Calculated Field is an extremely rich function in MVD. If you have a problem with it, ask Derek, he excels with calculated fields (and also Sparrow).
5 - Above all, do not give the names of your fields reserved words in Pascal. Instead, choose names that identify the function of the field. For names that are too long, reduce them with the _ sign
6 - Give your tables meaningful names that allow them to be easily identified
That should do it
JB
Re: a question
Thanks everyone
regarding my question I mean is it possible to create a new database from the application .exe
- Destiny
- Member
- Offline
Re: a question
Bonjour mouasomar, From your application go to "File" then "New Project"
Destiny