Jump to content
Sign in to follow this  
rain13

Need help with intermediate views

Recommended Posts

Hi!

I try to use HSQL database manager to create 2 views.

I want to create intermediate view first and then use the intermediate view in new view. Like create view a as .... . And then create view b as select x, ... from a.

If I write those 2 statements in HSQL database manager and hit 'Execute' query then it tells me user lacks privilege or object not found. However if I enter first create view statement, click "Execute SQL" and then write 2nd SQL statement ans click "Execute SQL" then it works.


The same happens when I migrate date from .sql files. If I put these 2 create view statements in separate .sql files it works but if I put them in same .sql file the 2nd one fails because first view is not created yet (the same error I showed before) However I have these statements separated with semicolon so it should not be issue.

Any ideas what it is? And how I could make it so that I could have only one .sql file that has both statements instead of having 2 separate files? 

Share this post


Link to post
Share on other sites

You'll need to check the documentation for that software to see what it supports.  That almost sounds like it's running everything in some strange type of transaction where the previous statements don't have any effect until everything finishes.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...