General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>Firstly, you need to assess why you are doing this (there are some valid reasons, but this is not the normal way). Generally, it is enough to define a few parameterized views and just let them live happily and permanently in a server dbc. Parameterized views, if defined correctly, usually give enough flexibility to allow your app to run without creating any custom ones.
Secondly, if you decide that temporary views IS the way to go, you need to be creating those in a temporary DBC on each users own hard drive, so you don't run into naming conflicts, etc.
The reason to have is we are creating more than 50 views.
We are saving it in the server and using sys() function getting a unique name for dbc. Is that the right way?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only