> > > Can anyone help me with creating temporary tables in place of the views, > > > which are available during runtime, which have the same fields and data > > > as my view such that when one table is updated, the results are appended > > > to the temporary table > > > > Why not just insert the content of the view into the temp table? > > > > insert into tmp_view_1 > > select * from view_1
Temp tables will not be updated unless you do it manually. You might talk to whoever is providing your software to connect the report writer to the database and ask them why views don't seem to work.
