Welcome to the official BlackBerry Support Community Forums.

This is your resource to discuss support topics with your peers, and learn from each other.

inside custom component

Native Development

New Developer
Posts: 104
Registered: ‎09-25-2013
My Device: BB 10
My Carrier: BB 10

sqlite3_clear_bindings() and crash

[ Edited ]

Hi All,


I am using SQLite databse for saving and updating the records in BB 10 cascades app.I got the below error mesage while updating the record and crashed once.


I try to reproduce the same many times(more than 100 times) but I didn't get the above message and no crash occured latter again.


bool DatabaseOperations::updateAlert(int id, QString alertName,QString price ,QString symbol_name, int serverid) {

	bool success = false;

	QSqlDatabase database = QSqlDatabase::database("init");
	QSqlQuery query(database);

 * CREATE TABLE Alerts "
					" Name VARCHAR(100), "
					" Status INTEGER, "
					"  AlertPrice VARCHAR(100), "
					"  AlertSymb VARCHAR(100));
	QString updateQuery = "UPDATE  Alerts"
			" SET Name = :name, "
			" AlertPrice = :price,"
			" AlertSymb = :symbol"
			" WHERE cust_pk_id = :ID ";

	Helper::writeToLog("Update price:"+price);
	Helper::writeToLog("Update symbol:"+symbol_name);

	query.bindValue(":name", alertName);
	query.bindValue(":price", price);
	query.bindValue(":symbol", symbol_name);
	query.bindValue(":ID", id);

	if (query.exec()) {
		Helper::writeToLog("Updated Alert Table");
		return true;

	} else {
		const QSqlError error = query.lastError();
		qDebug() << error;
	Helper::writeToLog("Not Updated Alert Table");
	return false;

 From the above code you can find the table structure and update query.


 If any body know it, please help !!!


New Developer
Posts: 104
Registered: ‎09-25-2013
My Device: BB 10
My Carrier: BB 10

Re: sqlite3_clear_bindings() and crash

I forgot you inform that I got the below messgase when the app was crashed.


Process 39182541 (mTadawul) terminated SIGSEGV code=1 fltno=11 ip=78644916(/base/usr/lib/libsqlite3.so.1@sqlite3_clear_bindings+0x205) mapaddr=00014916. ref=00000004 bdslot=1.