>
>That is true, although I have yet to experience designing/building objects that can support multiple types of DB.
>
>Kev
I thought is was going to be really hard, but it wasn't: I just created classes for handling data in VFP that fill cursors, derived classes (in my case for Oracle and Quickbooks) to handle the differences (mostly in dates and logical values) and then wrote an 'object factory' function to return the correct object for the product the customer is using (actually, I usually also have some tables in VFP, so I need to use both). I used a compile-time constant to determine the type, but you can also do it on-the-fly. I don't claim my classes are wonderful, but they do the job. For the ODBC stuff I attached Rick Strahl's wwSQL class to my own (why reinvent the wheel?).
Précédent
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