Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP and Oracle
Message
From
25/04/2007 02:15:32
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP1
Database:
Oracle
Miscellaneous
Thread ID:
01219325
Message ID:
01219649
Views:
8
Michael,

>...I think when our sales guys see how many clients either don't care or do not want the up front costs of an Oracle installation we'll probably go Sql Server, I hope.

However, if the sales guys still say major clients want Oracle, then why not do both? As Jordan said, CursorAdapter is a great technology to use when you want to use a variety of backend databases. Unlike remote views, CursorAdapter is subclassible, so you can build a set of classes that can talk to either.

The hard work is going to be converting the app to talk to ANY backend database -- tuning it for specific DB is the easy part and you can pretty much get two for the price of one (in coding time), although Oracle won't be cheap for the clients.
David Stevenson, MCSD, 2-time VFP MVP / St. Petersburg, FL USA / david@topstrategies.com
Previous
Reply
Map
View

Click here to load this message in the networking platform