Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
MySQL
Message
From
18/04/2002 11:18:34
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: MySQL
Miscellaneous
Thread ID:
00634559
Message ID:
00646380
Views:
25
I think very one is in favor of one connection interface but like cross platform it's just a dream. The best anyone can do (at the moment) is create a tool that can configure a backend class. A dataManager that somehow can change the methods to connect, Insert, Update, etc. Database engines are to different. Take a simple case:

MySQL = SHOW TABLES
Postgres = SELECT relname FROM pg_class WHERE NOT relname LIKE '%pg%'

These two are just the tip of the problem. From the VFP side there are two standard ways to connect ODBC or OLE DB. But someone could create a COM object to handle connections etc.

It's just a dream.
John
John Fabiani
Woodland, CA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform