Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Creating Views on the fly
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Creating Views on the fly
Miscellaneous
Thread ID:
00396744
Message ID:
00396744
Views:
37
Hi everyone,

One of my application currently uses predefined hidden filter technique. I think, that it would be better to use view instead. Threfore my question is: how can I create view on the fly? I pass TableName as a parameter, then I have to find owning database, open it, set it to be current and then create a view, right? I also have to delete this view programmatically in Form.Destroy method. Could you please give me a little help here? Also am I right in my assumption, that view should be faster, than filtered tables (I want to create a view based on one table with where equals filter condition)?

Thanks in advance.
If it's not broken, fix it until it is.


My Blog
Next
Reply
Map
View

Click here to load this message in the networking platform