Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Sql vs Oracle article on main page
Message
 
À
15/08/2001 09:15:13
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00543944
Message ID:
00545190
Vues:
14
>
>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
Fil
Voir

Click here to load this message in the networking platform