QSqlTableModel

[mazurekwrc]

maybe here

QString date = ValidToFilter->currentText();

QString date = ValidToFilter->currentText();

To copy to clipboard, switch view to plain text mode 

you get 9999-12-31 23:59:59 not 9999-12-31 23:59:59.000
so change

QString validationFilter = "dtValidTo='"+date+"'";

QString validationFilter = "dtValidTo='"+date+"'";

To copy to clipboard, switch view to plain text mode 

to

QString validationFilter = "dtValidTo like '"+date+"%'";

QString validationFilter = "dtValidTo like '"+date+"%'";

To copy to clipboard, switch view to plain text mode 

[codeman]

thank you.

So I change it in your way. now my view is not empty but in my datetime column there are some wrong filter elements. I choose 9999-12-31 23:59:59.000 as filter but there are also elements like this 30.06.2008 23:59:59 or see attachment for more detail ....

[mazurekwrc]

do you use

model->select();

model->select();

To copy to clipboard, switch view to plain text mode 

after setFilter ?

[codeman]

Yes I do. This is the actual code

void TableEditor::refresh()
{
    QString product = ProductFilter->currentText();
    QString date = ValidToFilter->currentText();
    QString eingabeFilter = "vcProductID='"+product+"'";
    QString validationFilter = "dtValidTo like '"+date+"%'";
    model->setFilter( eingabeFilter +" and "+validationFilter );
    model->select();
    view->setModel(model);
}

void TableEditor::refresh()
{
    QString product = ProductFilter->currentText();
    QString date = ValidToFilter->currentText();
    QString eingabeFilter = "vcProductID='"+product+"'";
    QString validationFilter = "dtValidTo like '"+date+"%'";
    model->setFilter( eingabeFilter +" and "+validationFilter );
    model->select();
    view->setModel(model);
}

To copy to clipboard, switch view to plain text mode 

It seems that the second filter argument don´t grab correctly ?????

[codeman]

So I solve the problem: It must be

QString validationFilter = "dtValidTo= convert (datetime,'"+date+"',120)";

QString validationFilter = "dtValidTo= convert (datetime,'"+date+"',120)";

To copy to clipboard, switch view to plain text mode 

[codeman]

But I have one question.

When I set the strategy from my SqlTableModel on manual, I have problems when I change a column with the mssql datatype Datetime on the server on submitting the datas.

For example in my model one entry in the column is 31.12.2008 23:50:59 and when I change something and try to submit it occurs an error.

What kind of problem I have to solve here???

[codeman]

Hello friends I locate the problem exactly now. It ist a Datetime field overflow.

The entry in the column is 9999-12-31 23:59:59 and whne I try to change it and submit it occurs the field overflow error.

The MsSql server holds this value in the database but why it occurs the mentioned error.??