Unsolved Creation SQLITE database
-
@Nafab213
Hi
For
db.setDatabaseName("......"); //Each User give an name at database
you can use https://doc.qt.io/qt-5/qinputdialog.htmlbool 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/ -
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.
-
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 -
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; -
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 -
@Nafab213
Hi, i talk about the return statement inif(!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. }
-
29/5000
Thanks mrjj
How can I fix that ?Thnks
-
@Nafab213
Hi
fix ?
the return ? just remove false;or do you mean 29/5000 ?
-
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. -
@mrjj said in Creation SQLITE database:
or do you mean 29/5000 ?
I guess 29/5000 is the amount of typed characters in this message :-)