>>>I have a sophisticated VFP desktop application that uses native VFP data. I am now working on writing a small application for the Web (using CodeCharge) that will allow the user to enter/edit some data. What is the best way to get my data from VFP to the Web application and back?
>>
>>If CodeCharge supports OLEDB connections to databases (it seems to:
http://docs.codecharge.com/studio3/html/UserGuide/WorkingWithProjs/ConnectingDatabases/ConnectingDatabases.html ) you can install the VFP OLEDB provider and let CodeCharge talk to your VFP data directly that way.
>
>Is this something you've done? Are there any issues with multi-users accessing the VFP data simultaneously?
No, I haven't used it. VFP Help is a good place to start, search on "OLEDB Provider". You can also search the messages here on "VFPOLEDB" for examples of its use.
The provider supports SET EXCLUSIVE, SET MULTILOCKS, SET REPROCESS etc. so you should be able to get it to play nicely when used simultaneously with your existing app.
If you're tempted to try ODBC connectivity to your VFP data, don't do it. The VFP ODBC driver only supports up to VFP6 SP5, it doesn't support the newer table and database features. AFAIK the OLEDB provider is the ONLY way that non-VFP apps can access native VFP7+ data. It's written by Microsoft, and the price is right, so it's worth a close look if your dev environment supports OLEDB database connections.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up