sql request that does not work

EL-jos

Hello, everyone,
I want to make a sql query that can create a table without first knowing the name that this table should have; here is my code:

int main(int argc, char** argv)
{
    QCoreApplication app(argc,argv);

    QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
    db.setDatabaseName("mydatabase");
    if(db.open()){

        qDebug("The connection is established with the database.");

        QSqlQuery q1;
        q1.prepare("CREATE TABLE :anonyme (id INT PRIMARY KEY NOT NULL, name VARCHAR(100) )");
        q1.bindValue(":anonyme","MyTable");
        if(q1.exec())
            qDebug("Successful request.");
        else
            qDebug() << "ERREUR: " << q1.lastError().text();
    }else{

        qDebug() << " ERREUR: ";
    }
    return app.exec();
}

I don't know why my code doesn't work.
and here is the error message: ERREUR: " Parameter count mismatch"
Thank you for your help.

Christian Ehrlicher

I don't see a problem - you can create your statement with the correct table name...
http://doc.qt.io/qt-5/qstring.html#arg

Christian Ehrlicher

You can only bind parameters, not table names or anything else. Just put 'MyTable' directly in to query.

CREATE TABLE MyTable (id INT PRIMARY KEY NOT NULL, name VARCHAR(100) )

EL-jos

Thank you for your answer;
Yes, you're right, but I want to create tables without first knowing the name of each one.

Note: I want the user to enter the name of the table to create

Christian Ehrlicher

I don't see a problem - you can create your statement with the correct table name...
http://doc.qt.io/qt-5/qstring.html#arg

EL-jos

Thank you so much for your help, it works now that God bless you.