SQLite in QT

I want to create a table in an existed database, and I have usccessfully opened the database.
How can I use the QSqlQuery::exec( QString& ) to create a table with the following fields:
id, INTEGER, the primary key
name, VARCHAR(90)
author, VARCHAR(50)
copy, INTEGER
press, VARCHAR(120)

AND, the table's name is a varible named "tableName".

Thank you very much!!

http://www.sqlite.org/lang_createtable.html

I'm sorry, but what do you mean??
I think I am asking a Qt related question, because I want to use SQLite in Qt, but it doesn't work well.

you have to prepare correct SQL-query for a table creation and wysota posted a link how to do this in right way.
EDITED: take a look at connection.h which is located in QTDIR/examples/sql.

I use this to create a table whick is a variable "tableName", why the following codes doesn't woek:

Code:

---

QSqlQuery build;
build.exec( QString("create table %1 ("
            "id INTEGER PRIMARY KEY AUTOINCREMENT,"
            "name VARCHAR(90)"
            "author VARCHAR(50)"
            "copy INTEGER"
            "press VARCHAR(120))").arg( name) )

---

and before these codes, I have open the database.
Thanks in advance.

what kind of error do you get? maybe this table already exists?

I don't know, I jusr use the following codes:

Code:

---

QSqlQuery build;
bool ok = build.exec( QString("create table %1 ("
            "id INTEGER PRIMARY KEY AUTOINCREMENT,"
            "name VARCHAR(90)"
            "author VARCHAR(50)"
            "copy INTEGER"
            "press VARCHAR(120))").arg( name) )
if( !ok )
    QMessageBox::information(this, "Fail", "Fail to create new table!!");

---

But I am sure the table doesn't exit.
puzzled.

modify you code like this

Code:

---

QSqlQuery build;
bool ok = build.exec( QString("create table %1 ("
            "id INTEGER PRIMARY KEY AUTOINCREMENT,"
            "name VARCHAR(90)"
            "author VARCHAR(50)"
            "copy INTEGER"
            "press VARCHAR(120))").arg( name) )
if( !ok )
    QMessageBox::information(this, "Fail", build.lastError().text());

---

and show us a result.

Oh, I have solved it !!
I miss the comma among the fields!!
Thank you for your replying.

ok, but anyway, use code which I posted above for determination errors, it will help you in a future.

Quote:

---

Originally Posted by sophister

Oh, I have solved it !!
I miss the comma among the fields!!
Thank you for your replying.

---

So after all your question was not related to Qt but to a proper SQL statement :cool:

Uh, yeah, you are right maybe.
I learn a lot from this forum.