Regarding overwritting the existing data in the QSqlRelationalTableModel

[Sudo007]

Qt 4.8
Does the QSqlRelationalTableModel::setFilter() overwrite the existing data in the model?
myModelModel->setFilter( QString("QueueID=%1 LIMIT %2 ,%3")
.arg( m_QueueId )
.arg( fromIndex )
.arg( toIndex ) );
if i call the myModelModel->rowCount(), it gives the total no. (existing + after filtered out).

how to get overwritting, i want rowCount of the model same always.

[VRonin]

QSqlRelationalTableModel::setFilter() works calling a select so it will rebuild the model. You could use or subclass QSortFilterProxyModel to do the filtering and retain the original model

[Sudo007]

@VRonin you mean after filtering out, existing data will be overritten.

[VRonin]

yes, calling setfilter will call select using the filter argument as WHERE clause so resetting the whole model