I'm working (as I've mentioned) on moving a large vertical from FPW screens (running in VFP) to VFP forms. It was originally based on the Stonefield Appmaker framework and we've created our own VFP framework based on making pretty much the minimal changes from the original Stonefield code. It's mostly converted and mostly working well, but we're running into a handful of issues that may all be related to locking. So I'm curious to hear what settings (especially for REPROCESS) folks are using.

In this case, we're using a buffering setting of 4-pessimistic table locking. The goal is that only person can be editing a given record at any time. In fact, we're also explicitly locking records when entering edit mode, including not just the record on the form, but other related records.

The most frustrating of the errors and the one that finally prompted this post is that every now and then, we're unable to lock a record in the table that we use for tracking primary keys. (The app has to remain compatible with FPW2.6, so auto-generated PKs aren't an option.) Weirdly, it happens more with the record for one particular table (which is not the largest table and doesn't have records added at a pace that might raise questions) than others.

So, how do you have your locking set up and what challenges have you run into?

Tamar