Terry: Thanks for that. Two questions, is there any overhead on the
web app running ipData.prg? For example, Stonefield's checking to see
if tables need updating has overhead if the database and tables are
large. Second is do your memo fields merge or overwrite? Many of my
memo fields have time stamped notes and overwriting would not be an
option. If someone on the web enters a note and someone on the local
computer enters a note, we need both of them.
Thanks!
On 12/20/2014 3:23 AM, Thierry Nivelet wrote:
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
[excessive quoting removed by server]
_______________________________________________
Post Messages to: [email protected]
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/[email protected]
** 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.
