Quote Originally Posted by stampede View Post
struct edit_setting_param param;

.
.

param.edit_lp = ui->edit_lp->text().toInt();
param.edit_hp = ui->edit_hp->text().toInt();
param.edit_lines = ui->combo_lines->currentIndex();
param.edit_avg = ui->edit_avg->text().toInt();
param.edit_window = ui->combo_window->currentIndex();
param.edit_pp = ui->combo_pp->currentIndex();

qDebug() << qDebug() << param.edit_lp << param.edit_hp << param.edit_lines << param.edit_avg << param.edit_window << param.edit_pp;
// debug output : 5 1000 4 5 0 0


QByteArray bytes((char *) &param, sizeof (param));

/* Insert into database */
pQ->prepare("insert into parameter (nama_param, id_tipe, id_unit, tag, note, setting) values (?, ?, ?, ?, ?, ?)");

pQ->bindValue(0, s_item.toAscii().data());
pQ->bindValue(1, s_id);
pQ->bindValue(2, id_select);
pQ->bindValue(3, s_init.toAscii().data());
pQ->bindValue(4, s_note.toAscii().data());
pQ->bindValue(5, bytes);


Now I want to show the BLOB data on Text Edit & Combo Box.

proses_q(Q, "select setting from parameter");
QByteArray data1 = Q->value(0).toByteArray();

bool ok;

qDebug() << data1.size() << data1.toInt(&ok, 16);
//debug output : 252 0.

the data value that I inserted to database is : 5 1000 4 5 0 0 , But when I selected data from database is : 0 ??