Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sql vs Oracle article on main page
Message
 
To
15/08/2001 09:15:13
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00543944
Message ID:
00545190
Views:
23
>
>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?).
Previous
Reply
Map
View

Click here to load this message in the networking platform