qt how to connect to sqlite db file

[TomASS]

Hello, I have a sqlite db file, it name is "tomek.sqlite". In this db I have a one table name: "am_tankowania"

In code, I put:

QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
 
    db.setDatabaseName("tomek.sqlite");
    if(db.open()) QMessageBox::information(0,"Ok","Connection ok");
    else QMessageBox::information(0,"Error","some error.");

QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");

    db.setDatabaseName("tomek.sqlite");
    if(db.open()) QMessageBox::information(0,"Ok","Connection ok");
    else QMessageBox::information(0,"Error","some error.");

To copy to clipboard, switch view to plain text mode 

The MessageBox ok - connection ok show. Now, I have a query:

select * from am_tankowania:

QSqlQuery query("SELECT * am_tankowania");
 if (query.lastError().isValid()) QMessageBox::critical(0,"Error",query.lastError().text() );

QSqlQuery query("SELECT * am_tankowania");
 if (query.lastError().isValid()) QMessageBox::critical(0,"Error",query.lastError().text() );

To copy to clipboard, switch view to plain text mode 

I see an error:
no such table table: am_tankowania Unable to execute statement :/

What i'm doing wrong?

Thank you.

[lyuts]

Well, this might be because db.setDatabaseName("tomek.sqlite"); points to a missing db file called tomek.sqlite. This should be a relative path. The reason is that probably your db file is not in the same directory as your executable.

The MessageBox ok - connection ok show.

It will always show ok. Because if there is no such file it will create it and open it (empty though).

[spirit]

this query looks wrong

QSqlQuery query("SELECT * am_tankowania");

QSqlQuery query("SELECT * am_tankowania");

To copy to clipboard, switch view to plain text mode 

change it to

QSqlQuery query("SELECT * FROM am_tankowania");

QSqlQuery query("SELECT * FROM am_tankowania");

To copy to clipboard, switch view to plain text mode