Advice about the application I will be making? (I'm a beginner)

[mrjj]

Hi
I cant see anything wrong.
Show how code is before the if ( mydb.open )

[dvlpr.bernard]

The code above is inside of this button function

Here's the declaration of the database

[JonB]

@dvlpr.bernard

• I notice that your Output window shows two occurrences of your message Connected.... Why is that? Are you connecting more than once?? [In a separate issue, in the long run you absolutely will not want to open() and then close() the database for each query. The whole point is to connect once, keep the connection open while you execute all your queries, and close when you are completely done with the database.]

• [...] but it didn't work also.

What does that mean? Error message? Behaviour? What?? Please help us to help you by supplying useful information.

[dvlpr.bernard]

@JonB @mrjj
if (query.exec( ))
always returns a false value thats why the query never gets executed.

[dvlpr.bernard]

I played around with the code and this error return.

[dvlpr.bernard]

[mrjj]

hi
are you sure the table name is mydatabase ?
seems wrong. unless the table is called taht.
But it seems you used the name of the database.

and it even says unknown table.
so use table name instead.

[JonB]

@dvlpr.bernard

no such table: mydatabase

@mrjj wrote:

are you sure the table name is mydatabase ?

Are you getting your database vs your tables mixed up in your head? You work with one database at a time. In SQLite that corresponds to the file you pass to setDatabaseName(), and is what gets opened via mydb.open(). A database may contain many tables, each with their own name. It is the table name you mention in SQL select (and most other) statements. You previously created your table(s) via some kind of CREATE TABLE name ... statement, and that name is what you need in your query. It would be "unusual" for you to have named a table mydatabase.

You might like to do yourself a favour, to help with all the SQLite queries you're trying to write. Download one of the (free) "workbenches" for SQLite. These are GUI applications which will let you see what is in your database; it will also let you construct and play with queries, till you are ready to copy them over to your Qt code. Google for sqlite workbench, there seem to be several, e.g. https://www.sqlite-workbench.com/, https://sqlitestudio.pl, https://alternativeto.net/software/sqlite-manager/. I suggest you take the time to pick one, in the long run I think the effort will be well worthwhile for you.

[dvlpr.bernard]

Good day.
So here is my database named codeanaldb with a table name "mydatabase". I didn't know why qt couldn't recognize it.

And here is the same query that I copy paste to qt but suddenly didn't work.

[JonB]

@dvlpr.bernard
In a word, Qt will "accept" any SQL query you can make work in a workbench. If it isn't something else is wrong, e.g. you're not connected to the database you think you are....

[KillerSmath]

@dvlpr.bernard said in Advice about the application I will be making? (I'm a beginner):

Are you sure that your database file is Database codeanaldb ? Because in last image you have used Database codeanal.db (with .)

[dvlpr.bernard]

Holly cow, after more than a 100 trial and error, I got it guys. So the problem is I didn't set the path correctly but I'm pretty sure I set it correctly earlier but then other code wasn't correct so I played around and tried change the path, I don't know why it is still working even if the path is wrong. So thank you again guys :).

Correct One: - connected and query is worling
mydb.setDatabaseName("C:\Users\bj\Documents\CODEANALL\Database\codeanaldb1.db");
Wrong One: - connected but the query isn't working dunno why
mydb.setDatabaseName("C:\Users\bj\Documents\CODEANALL\Database codeanaldb1.db");

[JonB]

@dvlpr.bernard

Correct One: - connected and query is worling
mydb.setDatabaseName("C:\Users\bj\Documents\CODEANALL\Database\codeanaldb1.db");
Wrong One: - connected but the query isn't working dunno why
mydb.setDatabaseName("C:\Users\bj\Documents\CODEANALL\Database codeanaldb1.db");

I suspect (never having used SQLite) that your existing database is the first path. When you specify the second path to open(), being non-existent SQLite decides to create that for you, as an empty database, which then does not have the table mentioned in the query/error message. Check your disk (directly in the CODEANALL folder) to see if the second one exists, or exists so long as you are running the query?

If that is the case, there "must" be some way of asking to open only an existent database/file from SQLite/Qt which you could use for safety?

[KillerSmath]

@dvlpr.bernard

I don't know why it is still working even if the path is wrong.

it is because, the QSqliteDriver uses by default, SQLITE_OPEN_CREATE flag to create the file if it is not exists.

[JonB]

@KillerSmath
Then the question is: can you specify something at open() time to override that behaviour, without changing the driver? Or, can you temporarily change that driver flag from code before opening? Then the OP would have found out/use it in future.

Meanwhile, the OP needs to understand that the two paths (one with space, one with backslash) refer to quite different files!

[dvlpr.bernard]

I see so that's the reason why there is a newly created database in my folder. Also backslash "\" specifies the parent folder. I have encountered that on web dev. Thank you!

[KillerSmath]

@JonB
Your answer is on sqlite source code.

Unhapply, that behaviour is only avoided if you are using SQLITE_OPEN_READONLY flag

[JonB]

@KillerSmath
Then @dvlpr-bernard might want to do a QFile::exists() check on the filepath prior to the open() if he wants to ensure he is opening a correctly-spelled existing database rather than accidentally creating a blank new one....

[dvlpr.bernard]

I tried different code but it didn't work. What should I do to replace query variable value with my variable in qt.
"select Answer from mydatabase where QQuantity = 5 and Topic = 'FOR' and Difficulty_Level = 'ADVANCED'"

[KroMignon]

@dvlpr.bernard This should work:

query.prepare("select answer from mydatabase where QQuantitiy=:qquantity AND Topic =:topic and Difficulty_Level =:difficulty_level")
query.bindValue(":qquantity", current_num);
query.bindValue(":topic", ch_topic);
query.bindValue(":difficulty_level", ch_div_lvl);

binValue will add necessary escape sequencies for string values.
you only have to ensure placeholder in prepare string is the same as which given to bindValue().

Read QSqlQuery Class for more details.