ASP create view on the fly

[jcale4]

HI!

Quick Question -

I have instances where i need to create views on the fly (since i cant seem to create global temporary tables in ASP). I have a feeling this is not customary ASP/RDBMS programming.

I am using classic ASP and my DBMS is IBM DB2 UDB. I have successfully created and dropped a view in the page, but was wondering if this is not a recommended practice.

Thanks!

 

[vbkris]

that depends, i have used views (for complex join queries). i would suggest a stored procedure as its compiled...

Known is handfull, Unknown is worldfull