🚀 go-pugleaf

in our application we have a DBGrid linked to a TADOTable that is filter on
user input. we have include a field (say Flag) in the table that is set to 0
or 1 depending on the user input, than table is filtered by "Flag = 1" (we
can't use the Filter/Filtered properties because the conditions can't be
write using SQL syntax).

first we set flag to zero in this way

    DB_Cmd->CommandText = "UPDATE [Article] SET [Flag] = 0";
    DB_Cmd->CommandType = cmdText;
    DB->BeginTrans();
    DB_Cmd->Execute();
    DB->CommitTrans();

than we set a complex filter (where f is a string build from user inputs):

    DB_Cmd->CommandText = "UPDATE [Article] SET [Flag] = 1 WHERE " + f;
    DB_Cmd->CommandType = cmdText;
    DB->BeginTrans();
    DB_Cmd->Execute();
    DB->CommitTrans();

last we reset some Flag (to zero) looking raw by raw.

if we don't close and reopen the table:

        T_Article->Active = false;
        T_Article->Active = true;

we can't see the right filter. Why? please help me, is very important.

thanks, Paolo