I am using the report designer and due to the nature of my database, i am selecting data from the database from a view and not a table. The select statement below selects data from 3 views.
select * from opsummary_diverter_a, opsummary_diverter_b, opsummary_diverter_c
I have a refresh button on my screen that runs some code to alter the tables…
fpmi.db.runUpdateQuery("ALTER VIEW opsummary_diverter_b AS " … … …
I have polling turned off on my dataset to help with performance.
Is there a way I can force a refresh of the dataset as the last thing I do in the buttons