Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
MySQL vs VFP
Message
From
04/12/2002 13:09:31
 
 
To
04/12/2002 09:47:52
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00729418
Message ID:
00729532
Views:
10
>i like interesting about Mysql database, but i don't have more information how to use that databse on VFP....anyone have try for this Database...Or you have a little sample maintenance(Update/Delete/Add/Etc) to Mysql...

The same way as with any other database you access through ODBC. Get their ODBC driver if you don't have it already. Install it. Create a DSN (from Control Panel or programmatically).

Then you can access your database from VFP with either SQL Pass-Through or Remote Views.

See the VFP manual Client-Server instructions and look at the following functions:
SQLConnect()
SQLExec()
SQLDisconnect()
There is a lot of good info in here (search the database) and at the VFP Wiki:
http://fox.wikis.com/wc.dll?Wiki~CategoryClient/Server

and
http://fox.wikis.com/wc.dll?Wiki~Client-ServerApplicationsWithVisualFoxPro6andSQLServer7~SoftwareEng


Alex Feldstein, MCP, Microsoft MVP
VFP Tips: English - Spanish
Website - Blog - Photo Gallery


"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry
Previous
Reply
Map
View

Click here to load this message in the networking platform