View Revisions: Issue #35887

Summary 0035887: TSQLQuery.ServerFilter exception on filter change
Revision 2019-07-26 08:18 by LacaK
Steps To Reproduce     qQuery.SQL.Text := ' select a.name from test_table a where 1=1 ';
    qQuery.ServerFiltered := True;
    qQuery.ServerFilter := ' name=''test value'' ';
    qQuery.Open;
    WriteLn(qQuery.FieldByName('name').AsString);
    qQuery.ServerFilter := ' name=''another value'' '; // <-------- here it will fail
    WriteLn(qQuery.FieldByName('name').AsString);

I attached a project with a small sqlite3 test database.
Revision 2019-07-25 21:32 by Andrei
Steps To Reproduce
    qQuery.SQL.Text := ' select a.name from test_table a where 1=1 ';
    qQuery.ServerFiltered := True;
    qQuery.ServerFilter := ' name=''test value'' ';
    qQuery.Open;
    WriteLn(qQuery.FieldByName('name').AsString);
    qQuery.ServerFilter := ' name=''another value'' '; // <-------- here it will fail
    WriteLn(qQuery.FieldByName('name').AsString);

I attached a project with a small sqlite3 test database.