Paul: The issue with moving from a VFP record-centric view of data to a cursor-centric view as is used in most client-server software is that there are a LOT of gotchas with getting VFP to work that way, and a lot of design decisions you need to make: do you use cursoradaptors, remote views, SQL Passthrough? All three are valid and work, but each has different limitations and issues you need to look out for. Do you use local cursors tied to the remote data? Or do you build your own data objects? Will you be switching backends, say from SQL Express to MariaDB? Then you need to think about a Data Manager and some translations. Do you buffer the local cursors? Do you buffer the remote data? How to you handle rollbacks? What's your strategy on data conflicts: last save wins, rollback and force a retry, or give the user edit controls of then-now-edited data?
>From experience, you can spend several years working through all of these questions, and building a robust underpinning to your application logic, and then find you need to alter your strategies as you see how your software is being used. Or, you can build your application using a framework someone else has already built. They have an opinion about which tools, commands and strategies to use, and you can build your app on top of their framework as you learn the details of how it works and perhaps why the decision decisions were made. You can ship an app in weeks or months vs. years and continue to enhance it rather than reinventing the wheel. Back in the day (oh, boy, here goes the geezer tales), I installed Visual Maxframe, read the documentation, and shipped the initial app in two weeks. I have worked with most of the major frameworks: Mere Mortals, Visual MaxFrame, Codebook, West-Wiind, Visual Extend. Sadly, I haven't worked with FoxExpress, which I also hear great things about and whose authors I count as friends. IME, any framework will get you up and running much faster than building it yourself. If you want to look at real code that people use in real production environments and have tested in real-life conditions, then check out the commercial frameworks. (I haven't shopped in a decade, so perhaps others can say which are still being maintained) There are also free ones. I know Codebook is available on this very forum (https://leafe.com/dls/cb) and there may be others available. On Mon, Feb 6, 2017 at 3:14 PM, Paul H. Tarver <p...@tpcqpc.com> wrote: > This is true, but the application was developed in MagicPC and my version of > that product only works with Btrieve v5 and will not work correctly with > later versions. We are able to function by using WinXP in a virtual machine > and quite frankly if that quits working, I can make it run in a DOS Virtual > machine if necessary. > > Thanks! > > Paul H. Tarver > Tarver Program Consultants, Inc. > Tel: 601-483-4404 > Email: p...@tpcqpc.com > > > -----Original Message----- > From: AndyHC [mailto:a...@hawthorncottage.com] > Sent: Sunday, February 05, 2017 5:02 AM > To: profoxt...@leafe.com > Subject: Re: SQL Backend Question - Part Deux > > According to Wikipedia the latest offering from Btrieve is backwards > compatible and runs on Win10 > https://en.wikipedia.org/wiki/Btrieve#Pervasive_PSQL_v9 > [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/CACW6n4tNsWFvgxeHe_MYxMdOY9ZwXOcKrAwfZ=hsgq47qx8...@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.