Steff, With FoxInCloud you move both app and data to the server. FoxInCloud comes with a VFP database sync class between LAN and web data so users can work either LAN or web without loss of data.
Otherwise, the best choice would probably be to move your data to a PostGreSql database and interact with either the local or the web-based postgre server. This involves rewriting data layer code. FoxInCloud's benefit is that your desktop application becomes truly web-enabled and works from within any browser (desktop, tablet, etc.). You save up to 98% of your existing code. VFP data behind a FIC app server is secured by NTFS. Thierry Nivelet http://foxincloud.com/ Give your VFP app a second life in the cloud Le 4 oct. 2011 à 19:43, "Jarvis, Matthew" <[email protected]> a écrit : >> Matthew: That describes what I would like to try. Having a desktop >> application access data files that reside on a remote server using the >> Internet as the connection between the two. > > > That's what I thought... > > For me it was easy-peasy since Paul did all the work... <g> > > I believe you just gotta have a DB backend installed (we used mySQL), > proper security to access the correct port, a log in to the DB... > > I sent him my DB schema and he put it in place on the back end, and I > filled it with my data from there on. > > Just remember to think in terms of 'connections' and 'data sets' since > you don't have that continous connection with the DB. If you want some > data you have to go fetch it (always only go get what you need i.e. no > more "SELECT *" unless you HAVE to)... you have to trap for a failed > attempt for any Fetches or Puts (updates or INSERTS). > > It's not hard, just a rethink of how us VFP folks are normally used to > doing things... > > Thanks, > > Matthew Jarvis || Business Systems Analyst > IT Department > McKenzie-Willamette Medical Center > 1460 G Street, Springfield, OR 97477 || Ph: 541-744-6092 || Fax: > 541-744-6145 > -------------------------------------------------------------------------- > Disclaimer: This electronic message may contain information that is > Proprietary, Confidential, or legally privileged or protected. It > is intended only for the use of the individual(s) and entity named > in the message. If you are not an intended recipient of this > message, please notify the sender immediately and delete the > material from your computer. Do not deliver, distribute or copy > this message and do not disclose its contents or take any action in > reliance on the information it contains. > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://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.
