We just installed a FoxInCloud application with this feature ...

Web site: upon startup, web app runs a program (ipData.prg) that adjust

the database and tables structure if needed (including views and stored

procs)

Local: a small VFP exe (ipMigrator.exe) doing this:

1- downloads ipData.prg from the web site, compiles and execute

(ensures that both sides have the very same database structure)

2- imports data from existing reference tables into the DB

(until other desktop apps have migrated to the new structure)

3- synchronizes data between local and the web site databases

(using a class supplied by FoxInCloud, 3 lines of code)

Here is the database diagram:

ftp://foxincloud.com/Screenshots/MCTG/ip.dbc.png

I can give you any other details you would like, including source code,

just let me know

Thierry Nivelet

FoxInCloud

Give your VFP app a second life in the cloud

http://foxincloud.com/

Le 19/12/2014 15:27, Jeff Johnson a écrit :

> When using something like Web Connection, is it better to use free

> tables rather than a DBC? Without the DBC you have more flexibility

> when changing file formats and I am not using any views on the web

> programming.

>

> TIA

>

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox

OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech

Searchable Archive: http://leafe.com/archives/search/profox

This message: http://leafe.com/archives/byMID/profox/54954E0A.7080803@foxincloud.com

** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.