Remove record without deleting it (or refreshing)

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Posts: 20
Joined: Mon 30 Oct 2006 09:15
Location: Belgium

Remove record without deleting it (or refreshing)

Post by rept » Mon 30 Oct 2006 09:20

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?

Posts: 512
Joined: Thu 26 Jan 2006 10:06

Post by Jackson » Mon 30 Oct 2006 13:13

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.

Post Reply