Creation SQLITE database

[Nafab213]

@JonB said in Creation SQLITE database:

I'm sorry but I simply don't happen to have code written which will do what you want. Perhaps someone else will, so I will not comment after this.
But I will say that others will find it difficult when your questions keep changing completely. First off I believe your push button was simply not being displayed, so I don't know what you were doing. Then you said you wanted to know how to create a database in SQLite. But now you are saying what you want to know are questions about cells merging, empty lines etc., which is simply in complete contradiction to not being able to connect to a database.
So I don't intend to be rude, but I think you should consider what your actual question is, for others to answer.

Excuse me then ..
Let's focus on the SQLITE database.
Look at the code of the database.
Is this correct?

[Nafab213]

Excuse me then ..
Let's focus on the SQLITE database.
Look at the code of the database.
Is this correct?

Thanks

[JonB]

@Nafab213
No, because I spot

"Sexe varcher (1)"

But then, politely, I didn't realise I was responsible for spotting spelling mistakes, having to look at every single character in what you have typed.

And then you also have:

                    "Varchar(20), "
                    "matiere(20),"

which are both obviously wrong. And nobody could possibly write this correctly for you, because they won't know what you actually want.

If you are going to have this level of problem, I would suggest you get hold of whatever equivalent of MySQL Workbench that SQLite provides (I know it provides something similar) and get the SQL code working there each time, before you copy it into your Qt code. You will get much better help on mistakes etc. interactively in a tool like that than direct from Qt code. This is not an "annoyance" for you, it looks like you really do need to do that in order to get anywhere productively.

[Nafab213]

I understood
For the "Sex Varcher (1)" because I would like to store a single letter in it.
either M for Male or F for Female.
It's good as that ?

For
                     "Varchar (20),"
                     "Material (20),"
It's a mistake I wanted to write
"matiere Varchar(20), "

I already corrected in the file.
Other errors?
Thank you....

[mrjj]

@Nafab213
Hi
For
db.setDatabaseName("......"); //Each User give an name at database
you can use https://doc.qt.io/qt-5/qinputdialog.html

 bool ok;
    QString text = QInputDialog::getText(this, tr("Add New Database"),
                                         tr("database name:"), QLineEdit::Normal,
                                         "default", &ok);
    if (ok && !text.isEmpty())
        databasename=text; //
....

Also this tool is super for inspecting the database and learn about it
https://sqlitebrowser.org/

[JonB]

@mrjj

For the "Sex Varcher (1)" because I would like to store a single letter in it.

No, because I said you have mis-spelt it. You need to look carefully at how you spell words, that is an extremely common part of programming for which you are really responsible. That's why I said you would really benefit from doing this in an interactive tool, not in code. Please do yourself a favor and download @mrjj 's link to https://sqlitebrowser.org/, believe me it's going to be worth it for you.

[Nafab213]

I received your answer and I will read the links afterwards.
So for my base ..
Do you have any advice to give me on my database?
Look at this part of my code ..

if(!db.open())
         {
             QMessageBox::critical(0, qApp->tr("Cannot open database"),
                 qApp->tr("La connexion n'est pas correctement établis à la base de donnée"
                          "Reprenez le processus.\n\n"
                          "Cliquer sur annuler pour quitter");
              return false ; //i don't know if it's necessary
         }

It's necessary ?
Thanks

[mrjj]

Hi
Yes, good error handling is always needed.
But the function it lives in has void as return.

void FenCene::newfiledb() // SLot no connected....
{ ...

so it should be just
return;

[Nafab213]

mrr
Excuse me but you talk about
"// SLot no connected ...."
{...
It's just a comment I forgot to take away.
Did you read my starting post?
Thnks

[mrjj]

@Nafab213
Hi, i talk about the return statement in

if(!db.open())
         {
             QMessageBox::critical(0, qApp->tr("Cannot open database"),
                 qApp->tr("La connexion n'est pas correctement établis à la base de donnée"
                          "Reprenez le processus.\n\n"
                          "Cliquer sur annuler pour quitter");
              return false ; //i don't know if it's necessary -> should just be return, since parent function has void as return.
         }

[Nafab213]

29/5000
Thanks mrjj
How can I fix that ?

Thnks

[mrjj]

@Nafab213
Hi
fix ?
the return ? just remove false;

or do you mean 29/5000 ?

[Nafab213]

When I compile it gives me a lot of error that I do not understand. And I will post the notifications on the forum but before I will correct syntax and vocabulary errors.
Thank you for your help.

[Pl45m4]

@mrjj said in Creation SQLITE database:

@Nafab213

or do you mean 29/5000 ?

I guess 29/5000 is the amount of typed characters in this message :-)