Kent, All i used to do is add a "lock status" field in each record and write to it when a successful lock was applied. this can be seen by everyone else and if you set an index to the field then it can quickly show you the locked records in a table. The only problem is if an app crashes out and doesn't "unset" the status in which case it will appear to be locked.
This method served me very well on my early accounts package back in the FPW days and is still in operation in the VFP version without change. You could also use Mutes objects if the apps are on the same machine, but unfortunately not on a network: http://www.news2news.com/vfp/?function=969 Christoff has a good article on Locking and the LockingPossible() function may be what you need (using API calls): http://www.foxpert.com/knowlbits_200910_1.htm Dave -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Kent Belan Sent: 03 May 2012 16:21 To: 'ProFox Email List' Subject: ISRLOCKED() Hello, I am trying to find a why to see if a record is locked by another user. Looks like ISRLOCKED() only works in the current app, so it is useless to tell if another computer locked the record. I know I can try to rlock() the record and if I get a lock, then it is not locked by others, duh ... But I don't want to lock a ton of records to show status in a list. Does anyone have an API or trick to see if a record is locked by another computer ? Thaks, Kent [excessive quoting removed by server] _______________________________________________ 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/[email protected] ** 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.
