My Visual Database — a question

Re: a question

null@example.com (Destiny) — Tue, 03 Sep 2024 06:56:56 +0000

Bonjour mouasomar, From your application go to "File" then "New Project"

Re: a question

null@example.com (mouasomar) — Mon, 02 Sep 2024 18:11:37 +0000

Thanks everyone
regarding my question I mean is it possible to create a new database from the application .exe

Re: a question

null@example.com (jean.brezhonek) — Mon, 02 Sep 2024 16:25:55 +0000

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

null@example.com (v_pozidis) — Mon, 02 Sep 2024 12:16:11 +0000

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)

Re: a question

null@example.com (Destiny) — Mon, 02 Sep 2024 12:00:25 +0000

Find on the forum

a question

null@example.com (mouasomar) — Mon, 02 Sep 2024 11:17:08 +0000

1- Can the program create a new, empty database?
2- How do delete all data in the table grid at once?