create_sql = "create table member (id int primary key, name varchar(30),address varchar(30))"; insert_sql = "insert into member values(?,?,?)"; select_sql = "select * from member";
db = QSqlDatabase::addDatabase("QSQLITE"); db.setDatabaseName("xin.db"); if(db.open()) { qDebug()<<"database open!";
sql_query = QSqlQuery::QSqlQuery(db); ///////////// sql_query.prepare(create_sql);
if(sql_query.exec()) { qDebug()<<"table create success!"; } else { qDebug()<<sql_query.lastError(); }
}
db和sql_query声明的是全局变量,只要第2次运行就会报QSqlError("", "Unable to fetch row", "No query") 把xin.db删了就不会报错,请问这该怎么破?