Database and QSqlQuery::prepare problem

**fengtian.we** · 31st October 2007, 22:43

mycode:

Qt Code:

Switch view

void MainWindow::test()
{
	QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");
	db.setHostName("localhost");
	db.setDatabaseName("mytest");
	db.setUserName("root");
	db.setPassword("111111");
 
	if (!db.open())
	{
		QMessageBox::information (this,"Database Error",db.lastError().text());
	}
	else
	{
		qDebug() << "Database OK";
	}
 
	QSqlQuery *query=new QSqlQuery(db);
 
	query->prepare("insert into testtable(t_data1,t_data2) value(?,?)");
	query->addBindValue(3);
	query->addBindValue(55);
	query->exec();
 
	qDebug() << query->lastError().text();
}

void MainWindow::test()
{
	QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");
	db.setHostName("localhost");
	db.setDatabaseName("mytest");
	db.setUserName("root");
	db.setPassword("111111");

	if (!db.open())
	{
		QMessageBox::information (this,"Database Error",db.lastError().text());
	}
	else
	{
		qDebug() << "Database OK";
	}

	QSqlQuery *query=new QSqlQuery(db);

	query->prepare("insert into testtable(t_data1,t_data2) value(?,?)");
	query->addBindValue(3);
	query->addBindValue(55);
	query->exec();

	qDebug() << query->lastError().text();
}

To copy to clipboard, switch view to plain text mode

output :
Database OK
"Using unsupported buffer type: -842150451 (parameter: 2) QMYSQL3: Unable to bind value"

database is not change. why???