Good point, Bernd. I will implement that also. Pat On Tue, 28 Aug 2018 at 07:46, Bernd Fröhlich via 4D_Tech < [email protected]> wrote:
> Pat Bensky: > > > The important thing is that all record cancellations go through a > > *CancelRecord* method. > > I created a [SpareRecordNumbers] table which contains 3 fields: unique > id, > > table number, and spare record number > > > As I said, it hasn't been thoroughly tested yet. So please feel free to > > chime in if you can see any flaws! > > > I have a similar system for invoice numbers. > Works perfectly in theory but in real life once or twice a year we got a > missing invoice number. > Took me some time to figure out how it got lost (very obvious, once you > know): > > User starts writing the invoice - gets a number through the system. > User goes home, leaving the invoice open. > User is disconnected, so the number is never returned. > > Now I look for lost number on every restart and if I find one I put it in > the recycling bin. > Never lost a number since. > > Greetings from Germany, > Bernd Fröhlich > ********************************************************************** > 4D Internet Users Group (4D iNUG) > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:[email protected] > ********************************************************************** -- ************************************************* CatBase - Top Dog in Data Publishing tel: +44 (0) 207 118 7889 w: http://www.catbase.com skype: pat.bensky ************************************************* ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
