Author: Jeff Johnson
Posted: 2014-12-20 at 07:55:19
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
>
> 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: 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/54957FC7.4090408@san-dc.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.