I need that table to be temporary and non persistent because it is updated very quickly on a system which has an micro SDHC card as the storring hardware. I don't know how to create this table in this way and also to have the view created and recompiled.
Do you have any ideea? Thank you! On Thursday, June 20, 2013 3:45:33 PM UTC+3, Noel Grandin wrote: > > > CREATE FORCE VIEW is not intended to work like that, it is purely there > for the case of dealing with dependent views. > > Why are you trying to use a temporary table behind a view, what exactly > are you trying to accomplish? > > On 2013-06-20 13:45, Andrei Manz wrote: > > The temporary table is gone (as it should be) but the problem is that > > also the view is gone! > > I don't think that is supposed to delete also the view. > > > > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
