Parameter count mismatch in create table statement

[croscato]

Hi all! I have the following code to manipulate a sqlite3 database:

const QString SQL_INSERT_LANGUAGE =
    "INSERT INTO languages VALUES ("
        "null, :language, :abbreviation"
    ")";
 
const QString SQL_CREATE_TABLE_WORD =
    "CREATE TABLE :table ("
        "word VARCHAR UNIQUE, "
        "a INT, b INT, c INT, d INT, e INT, f INT, g INT, h INT, "
        "i INT, j INT, k INT, l INT, m INT, n INT, o INT, p INT, "
        "q INT, r INT, s INT, t INT, u INT, v INT, w INT, x INT, "
        "y INT, z INT, "
        "len INT"
    ")";
 
bool DB::addLanguage(const QVariant & language, const QVariant & abbreviation)
{
    QSqlQuery query((*mDatabase));
 
    query.prepare(SQL_INSERT_LANGUAGE);
    query.bindValue(":language", language);
    query.bindValue(":abbreviation", abbreviation);
 
    if (query.exec() == false) {
        qDebug() << "ERROR 1 = " << query.lastError();
 
        return false;
    }
 
 
    query.prepare(SQL_CREATE_TABLE_WORD);
    query.bindValue(":table", abbreviation);
 
    if (query.exec() == false) { // The error is in this query
        qDebug() << "ERROR 2 = " << query.lastError();
        qDebug() << "SQL = " << query.executedQuery();
 
        return false;
    }
 
    return true;
}

const QString SQL_INSERT_LANGUAGE =
    "INSERT INTO languages VALUES ("
        "null, :language, :abbreviation"
    ")";

const QString SQL_CREATE_TABLE_WORD =
    "CREATE TABLE :table ("
        "word VARCHAR UNIQUE, "
        "a INT, b INT, c INT, d INT, e INT, f INT, g INT, h INT, "
        "i INT, j INT, k INT, l INT, m INT, n INT, o INT, p INT, "
        "q INT, r INT, s INT, t INT, u INT, v INT, w INT, x INT, "
        "y INT, z INT, "
        "len INT"
    ")";

bool DB::addLanguage(const QVariant & language, const QVariant & abbreviation)
{
    QSqlQuery query((*mDatabase));

    query.prepare(SQL_INSERT_LANGUAGE);
    query.bindValue(":language", language);
    query.bindValue(":abbreviation", abbreviation);

    if (query.exec() == false) {
        qDebug() << "ERROR 1 = " << query.lastError();

        return false;
    }


    query.prepare(SQL_CREATE_TABLE_WORD);
    query.bindValue(":table", abbreviation);

    if (query.exec() == false) { // The error is in this query
        qDebug() << "ERROR 2 = " << query.lastError();
        qDebug() << "SQL = " << query.executedQuery();

        return false;
    }

    return true;
}

To copy to clipboard, switch view to plain text mode 

The first query executes with no problem. But when the second one is executed it give me the "Parameter count mismatch".

Please, can someone help me???

Thanks!!!

[lyuts]

Did you try to run the same query from the sqlite3 terminal? What are the errors?

[croscato]

In the sqlite3 terminal it works correctly. I think the problem is in the parameter binding.

[ftrastour]

Hi,

Are you sure that prepare reset bound values ?

Perhaps could you try to 'clear' the query before to 'prepare' it for the second time.

Fred.

[croscato]

I have cleared the query but it give me the same error.

I think now that the problem is that the "binding placeholder" is the table name in que Sql statement. I think it only work if you try to bind a parameter.

[remy_david]

I think it only work if you try to bind a parameter.

That's the case.