Remove record without deleting it (or refreshing)

[rept]

I have a TMSQuery and also a TMSStoredProc where the query selects some fields based on a few conditions.

Now suppose the list is 50 rows long. I change a column for one row so it doesn't meet the supplied conditions for the query. How can I remove that row from the query without deleting it (in the DB) or having to reload (or reopen) the complete query?

Is there a command that removes a row from the TMSQuery or TMSStoredProc without deleting it in the DB?

[Jackson]

SDAC doesn't have such method but you can specify in TDataSet.Filter property the same conditions as in your WHERE clause and set TDataSet.Filtered := True.