Qsqltablemodel incompatible data types
-
I have a simple form with button and some line edits and listview.
In listview users can select items and in line edits edit their parameters.@
int row = listView->selectionModel()->currentIndex().row();
QString text = ui->lineEdit->text();
sqlTableModel->setData(sqlTableModel->index(row,3),title,Qt::EditRole);
sqlTableModel->submitAll(); //when this line is execeute i get an error
@error:
QODBCResult::exec: Unable to execute statement: "[Microsoft][SQL Native Client][SQL Server]The data types varchar(max) and ntext are incompatible in the equal to operator. [Microsoft][SQL Native Client][SQL Server]Statement(s) could not be prepared." -
Issue is coming from Microsoft SQL where nnext is deprecated nvarchar. You can hit the google and fix this issue with Microsoft SQL. I saw many solutions available for this to fix. You can check the following link as well.
"http://stackoverflow.com/questions/3543570/ntext-comparison":http://stackoverflow.com/questions/3543570/ntext-comparison
