Devart Forums

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?

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.