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 <paul@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: paul@tpcqpc.com

>

>

> -----Original Message-----

> From: AndyHC [mailto:andy@hawthorncottage.com]

> Sent: Sunday, February 05, 2017 5:02 AM

> To: profoxtech@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=HSgq47qX8S4w@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.