revert to stored query in macro

asked 2017-11-05 16:44:23 +0200

xoristzatziki gravatar image

I have an ExecuteReport macro to create any report using filters (I am not sure where I got this). The macro changes the query to use the filter and then opens the report. composer = aConnection.createQueryComposer, composer.setQuery( aConnection.Queries.getByName( aQueryName ).Command ), composer.setFilter( aFilter )

That action renders odb as unsaved but also changes permanently the report. I find a way to revert to report using beforefilter = composer.ComposedQuery and finally aConnection.Queries.getByName( aQueryName ).Command = beforefilter. But this marks odb as changed, making user uncertain what to do (is something changed? was an error? etc).

Is there any way to "undo" the filter condition (only, not any other changes) in order to make odb happy?

edit retag flag offensive close merge delete