George, Don't even try to run with VFP over either a WAN or wireless as it is far to slow and when it crashes it will probably end up corrupting the VFP tables. As Mike so rightly says step up to Client Server (M$SQL server (Free version) or MySQL (or equivalent). The data transfer requirement is minimal, you will never have to bother about drop outs or bandwidth and it will simply work.
You can access the server via either SQL Pass Through (SPT) or using Cursor Adapters (CA's) very easily and once you get your head around disconnected data sets and 3 tier data layers then it is plain sailing. The free Microsoft SQL Server Express is more than capable of supporting data volumes for small businesses and is totally free (as is MySQL) and performance is excellent. Changing to Client Server does require a rethink in terms of how you design your Business Logic in order to separate it from your presentation layer but makes life very simple if you ever come to change the Data Storage Layer from one server to another. The other advantage is that you can design your programs/systems to be easily maintained as opposed to using "standard VFP" where all the layers are contained in one level of program and changing one aspect normally has a knock-on detrimental effect. Lots of people on the group are well versed in Client Server technology and there are excellent resources out there written by very knowledgeable VFP people. Ask away on here and you will get virtually limitless advice and help. Best of luck (not that you will need it!) One other option you also have of course is to migrate your software onto FoxInCloud which unfortunately I cannot comment on in terms of ease of transfer or suitability but it has had some good press and a section that allows you to see exactly what changes would be required to your existing source code. Contact Thierry Nivelet who frequents here for details. Dave -----Original Message----- From: ProFox [mailto:[email protected]] On Behalf Of G Gambill Sent: 13 May 2016 04:25 To: ProFoxTech List <[email protected]> Subject: DBF Records on a Web Server and EXE on Local Box Is it possible to read web based DBF records (a limited number of records) on a local box. Memo fields do not apply such that converting the DBF file to an SQL might be better. If I can leave the data as a DBF, how do I do it? If SQL is better both short term and long term, how do I do that? Best conversion program and reading Web based SQL from a local box code suggestions? TIA George -- Success builds confidence. Failure builds knowledge. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [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.
