For that you should read This Thread.
Two methods I use when creating a portable app is to create the queries in seperate classes for each different DB expected to be used. Then;
1/ Have a "driver" class using case (switch) statements to route the called method to the appropriate class method. You then provide a configuration file to tell the app which DB is being used.
2/ Use the directX approach to abstraction and only install the class module for the db that will be used. The configuration can then be included in the class module.
Method 2 is the simplest, when you know the environment that the app will be installed in. And method 1 gives flexibility when the app is being installed for the end user to select what is available.
__________________
Chris. ->> Links are advertising NOT optimising!! <<-
A foolish consistency is the hobgoblin of little minds
Thought for today:- I SEO the only industry where all the cowboys are Indians?
|
