> I'm not sure I trust RLock(). I'd probably use a "Status" field that > indicates the record is unprocessed, in process, or processed. This might > be a good use case for Christof's DMult multi-threading utility
You still have to use either RLOCK() or a SET REFRESH value of -1 to read the status field, because otherwise VFP will lie to you about the current value of that field. Unless you move away from a record, you get the same value for hours in VFP. Even if you move away, the cache is considered to be the truth for up to how many seconds SET REFRESH indicates. Christof _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/8bc9aee1-ed4a-43b2-b3db-6bf3c5b91...@wollenhaupt.org ** 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.