>You may just have to bite the bullet and do both. Think about this one, one of the companies I work for bit the bullet and we "talk" to either VFP, SQL-Server or Oracle and use only one code set. We wrote a class called a query agent which allows us to create a cursor object to which we populate properties such as from, fields, where, etc. When a user logs in, they have an option to select which database (or databases) they want to connect to. The query agent receives the cursor object from the caller and creates a SQL string to get the data based on what database the user is connected to. This class is powerful enough to where we can actually connect to a database of each type and display 3 end-user queries, one from each database. But the real beauty of it is that we do this with one VFP code set. We even had Oracle consultants tell us that what we wanted to do couldn't be done.....guess we just couldn't take that for an answer.
>
Steve, tell me more about the query agent, please.
Thanks, Alex
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement