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