Hey Dave, Thanks again for your input. I was actually communicating with Stephen offlist - and he also suggested moving towards SQL type access - but, in a bit of a different method than you suggested here.
The Buffering into in the link below looked very interesting - and I started reading it - but, people are always in a rush here - and there isn't always enough to read something long like that webpage. But, I will do my best to try and get to it. I found the explainations of the Buffering thing very interesting - as I haven't fully used that much. Stephen also suggested using Transaction type processing - and I may implement that as part of my solution here! L8r, -K- -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dave Crozier Sent: Wednesday, February 03, 2010 11:46 AM Kurt, Personally I would do away with the rlock() and replace commands and use sql update statements with the relevant method of buffering. Take a look at Andy Kramek's discussion on the subject: http://weblogs.foxite.com/andykramek/archive/2005/10/18/948.aspx or http://tinyurl.com/yld8ka8 I have used Rlock() and Flock() in the past with very few problems but the SQL route is more consistent with the VFP locking thinkset. Also I would seriously look at whether the Disk Caching for writing is disabled on the server if that is where you are getting the data from. What may well be happening is that the VFP program may be throwing data at the server faster than the old DOS software, hence the possibility of data conflict. The other solution is to Flock() the file and only allow access as required in the equivalent of single user mode but this may well slow the process up. You will find that the Flush command is in fact redundant when using a server configuration. http://www.west-wind.com/wiki/wc.dll?wc~TableBufferingProblemsWithVFP or http://tinyurl.com/yzjchqk Dave Crozier -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Kurt Wendt Sent: 03 February 2010 14:54 Hey folks, One of the users of our system has recently started having a problem (and they recently switched from our older DOS based system to the newer VFP based system - even though the VFP system is still DOS looking with the same color scheme and fonts). The problem is that they got a duplicate Purchase Order # and previously a duplicated Invoice #... _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/289ea162f5642645b5cf64d624c66a14071a1...@us-ny-mail-002.waitex.net ** 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.
