How to Insert and Delete row from query?

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Romano
Posts: 41
Joined: Tue 10 Feb 2009 11:21

How to Insert and Delete row from query?

Post by Romano » Tue 10 Feb 2009 11:39

Hi,
I'm newbie in SDAC. I would like to know how I can insert new record to or delete some record from TMSQuery?
I have query for viewing data in grid. And independent actions for new, edit and delete. I need add new inserted record to grid query without generetion insert to DB (insert I did myself before). How I can do it?
And how I can delete some record - the same situation - I have independent action for delete? I don't want to use Refresh or QuickRefresh.
I need something like local edit...

Thanks
Roman

Romano
Posts: 41
Joined: Tue 10 Feb 2009 11:21

How to Insert and Delete row from query?

Post by Romano » Wed 11 Feb 2009 09:07

OK, I found solution: CachedUpdates :D ...

Roman

Dimon
Devart Team
Posts: 2885
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Wed 11 Feb 2009 09:29

It is good to see that this problem has been solved.

Post Reply