QSqlQuery Problem 2

[damodharan]

Dear All,

i created a table like this ,
i need primary key for both column -- id,FNumber

ret = query.exec("create table FilterNumTable "
               "(id integer,"
               "FNumber varchar(20),"
               "Enable varchar(30),"
               "Disable varchar(30),"
               "PRIMARY KEY (FNumber , id))");

Table itself not creating>any one have idea in QT to how to creata a table with two
primary column.

[damodharan]

thx to all,
issue resolved.

[divanov]

Did you forget semicolon at the end of the SQL query?

[damodharan]

Did you forget semicolon at the end of the SQL query?

no no divanov, syntax is correct,i normal sqllite i check the syntax its working fine.
but now i am checking in Qt how its taking two primary key in single table,

[divanov]

I was not able to reproduce the problem

#include <QtCore>
#include <QtSql>

int main(int argc, char *argv[])
{
    QCoreApplication a(argc, argv);

    QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
    db.setDatabaseName("customdb");
    if (!db.open())
        qDebug() << db.lastError();
    QSqlQuery q;
    q.prepare("create table FilterNumTable "
               "(id integer,"
               "FNumber varchar(20),"
               "Enable varchar(30),"
               "Disable varchar(30),"
               "PRIMARY KEY (FNumber , id))");
    if (!q.exec())
        qDebug() << q.lastError();

    qDebug() << db.tables();

    db.close();
}

[danhicksbyron]

Qt doesn't do anything to the query arguments other than to wave at them as they pass. If it works in stand-alone SQLite, it should work in Qt SQLite.

[damodharan]

Qt doesn't do anything to the query arguments other than to wave at them as they pass. If it works in stand-alone SQLite, it should work in Qt SQLite.

thx for ur ans danhicksbyron.