Trouble with "INSERT" by QSqlTableModel

[caduel]

looks like the order of the fields is not as you expected (seems like column 1 is "security"; you can check by displaying the QSqlTableModel in a QTableView).

How about this approach:
populate (access columns by name) a QSqlRecord (you get an empty one with record()) and insert it with QSqlTableModel::insertRecord()
This way your code does not depend on the order of the columns in the table.

HTH

[AD]

looks like the order of the fields is not as you expected (seems like column 1 is "security"; you can check by displaying the QSqlTableModel in a QTableView).

How about this approach:
populate (access columns by name) a QSqlRecord (you get an empty one with record()) and insert it with QSqlTableModel::insertRecord()
This way your code does not depend on the order of the columns in the table.

HTH

// Добавление серийного номера
bool AddSerialNumber::add()
{
    while(element -> serialName.size() <= 8)
        element -> serialName += (QChar)32;
 
    int modelID = selectModelID();
QSqlTableModel model;model.setTable("DeviceList");
model.setEditStrategy(QSqlTableModel::OnManualSubmit);
model.select();
QSqlRecord record = model.record( );
record.setValue("serialNumber", element -> serialName);
record.setValue("secretKey", element -> secret );
record.setValue("security", true);
record.setValue( "modelID", modelID);
model.insertRecord(-1, record);
bool ins = model.submitAll( );
 
return ins;
}

// Добавление серийного номера
bool AddSerialNumber::add()
{
    while(element -> serialName.size() <= 8)
        element -> serialName += (QChar)32;
 
    int modelID = selectModelID();
QSqlTableModel model;model.setTable("DeviceList");
model.setEditStrategy(QSqlTableModel::OnManualSubmit);
model.select();
QSqlRecord record = model.record( );
record.setValue("serialNumber", element -> serialName);
record.setValue("secretKey", element -> secret );
record.setValue("security", true);
record.setValue( "modelID", modelID);
model.insertRecord(-1, record);
bool ins = model.submitAll( );

return ins;
}

To copy to clipboard, switch view to plain text mode 

This code doesn't works too. submitAll return false

[AD]

Au! Help, please!

[caduel]

any error message / debug output that could help us?

[AD]

This error is:

[Microsoft][SQL Native Client][SQL Server]Operand type clash: text is incompatible with bit [Microsoft][SQL Native Client][SQL Server]Statement(s) could not be prepared. QODBC3: Unable to execute statement

ODBC driver work right. Intructions UPDATE, SELECT works, INSERT with QSqlQuery works!

[caduel]

i) dump the QSqlRecord to stderr, check esp. the QVariant::Types of the fields
ii) if those do not match your db: fix the setValue calls to the record to be inserted
iii) assuming those are correct: file a bug report to the Trolls