Graham, On the Index table how are you locking the parameter (Next record Id) table? 99% of the time VFP will do this automatically for you but I prefer the Rlock()/Flock() manual method, that way I can be SURE of getting no duplicates. This is the ONLY time I ever use manual locking however.
Dave Crozier -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Graham Brown (CompSYS) Sent: 07 February 2007 14:46 To: ProFox Email List Subject: RE: To flush or not to flush, that is the question Hi John Haven't had chance to look at 9 yet. My libraries are tried and tested on v8 so need to get some spare time to check with 9. btw the scenario I have is exactly as you say, a parameters table holding the next available number. Will look at autoincs thanks. I've put the flush code out there today so will see if this fixes the problem, like you say it is highly intermittent (twice in a year!) Will also post back in a little while when I've got some feedback. Regards -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of John Weller Sent: 06 February 2007 18:13 To: profox@leafe.com Subject: RE: To flush or not to flush, that is the question How are you generating the invoice numbers - from a table holding the next number? I had a problem like this generating primary keys using a next number table on a couple of apps. It be-devilled us for years, I couldn't find what was causing it as it seemed to be intermittent - it only went away when I upgraded and started using auto incrementing fields. Why upgrade to VFP 8, why not VFP 9? John Weller 01380 723235 07976 393631 > > > I've got a weird problem whereby I get duplicate invoice numbers in a vfp6 > native app. Does a tableupdate issue a flush at the same time? It has just > duplicated today for the second time in about a year. > > [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** 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.
