Hi Paul: There are many options available, and all depends on what type of support you need (Microsoft?, Community?, 3rd.party?), may be the type of application and how much you want to $pend in the technology/tools (privatative tech/tools, Open Source tech/tools or a mix).
If you want it to be desktop, and do not mind distributing in every user PC, then you can use .Net, Python, Java, xHarbour and some others. If you want web-based because of a centralized distribution on the intranet and let open the possibility of using it from Internet, then you can use Angular2, NodeJS, React, PHP, Python and others. Specially React (used by Facebook) have a good performance and virtual DOM (something like VFP's Table Buffering) I did not yet made any migration between technologies, but this is what I see around and what I've read about too. 2017-02-02 15:54 GMT+01:00 Paul H. Tarver <p...@tpcqpc.com>: > Ok, I've lurked here long enough. I've been subscribed to this list for > several months and I have thoroughly enjoyed the questions and answers that > have come through during that time. I'm even a little star-struck when I > see > the names of Foxpro experts that I have depended upon for years to help > educate me to be a better Foxpro programmer. Thank you all for all you do > in > this list group. Now it is time for me to ask what is probably going to > sound like a dumb question coming from someone who has been using Foxpro > since Foxlan but I figure I have nothing to lose here and everything to > gain. > > > > For the past few years I have been honing my skills as a developer of data > interfaces and until recently, the few full-fledged data entry projects > I've > build relied upon native Foxpro dbf files. However, my interface work has > been depending more and more upon using SQL pass-through language to issue > queries against various SQL backend systems and I have been pretty > successful at retrieving data from various systems and then re-formatting > that data for other uses. > > > > For a while now, I've been contemplating building a data-entry and > maintenance system from the ground up that depends completely upon using a > SQL database (Firebird, MySQL, MS SQL, Postgres or something similar). My > problem is that I have all these data handling classes built into a couple > of simple toolbars that I can drop on form and provide the standard Add, > Delete, Undo, Save and Exit functionality as well as a vcr toolbar to skip > between records. These tools include all of the code necessary to detect > changes enable various buttons based on conditions, etc. stuff we are all > familiar with. > > > > Now I'm trying to wrap my head around the whole concept of changing the way > I depend upon Foxpro to handle much of the behind the scenes table activity > and create a new user interface that conforms to the how SQL works while > maintaining as much of the familiar functionality I'm so happy with in > Foxpro. > > > > Does anyone have any recommendations for where I should go to learn more > about the best practices for developing user interfaces that work > efficiently with SQL backends, and what do I need to know about how to > collect data and insert it into the sql tables, detect user changes to flag > for saving data. In some software they seemed to have ditched the Add, > Delete, Undo, Save, Exit concept to just save everytime there is keystroke. > And in other systems, they keep parts of that old style of user > interaction. > Are there any libraries that can be purchased or downloaded to handle some > of the behind the scenes data manipulation for SQL that I can use to learn > how this stuff should work. > > > > For something that seems to be easy, I'm having a hard time letting go of > my > 20+ years of doing things the Foxpro way to make the transition. > > > > Any thoughts? > > > > Paul H. Tarver > Tarver Program Consultants, Inc. > > > > > > --- StripMime Report -- processed MIME parts --- > multipart/alternative > text/plain (text body -- kept) > text/html > --- > [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/cagq_jumtrpcbydunwwnts3ia3nlwrm+q+ey+ar2bvytbpwo...@mail.gmail.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.
