How to Insert and Delete row from query?

Romano · 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 · Post by **Romano** » Wed 11 Feb 2009 09:07

OK, I found solution: CachedUpdates

...

Roman

Dimon · Post by **Dimon** » Wed 11 Feb 2009 09:29

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