Creation SQLITE database

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 :-)