VB6, SQL-Server 7 and the Data Environment
Posted on 2000-04-11
I am writing a client/server application using VB6 and SQLServer7. I've made good use of the DataEnvironment object to manage and create connections to tables etc. M question: What are the advantages and disadvantages of DataEnvironment SQL Commands in comparison to using View commands.
Is there a speed enhancment by having the view on the server? Are there any limiting factors in having the view on the server, i.e. how does security work? Does the view inherit its security from its source tables or do you need to assign permissions to the view seperately?
If I used views could I write code to create the view in the first place? The reason for this is so I can maintain the application with "patch updates"
Thank you in advance.