>As long as you have only one table in your SQL query, you can use the ISRLOCKED() function as one of you columns.
>
>
select *,isrlocked() as locked from mytable into cursor c_temp
>
A big problem here is that isrlocked() only reflects if the local system holds a lock on the record in question, it does not tell you if the record is eligible to be locked by the local system. And since the lock status can change over time, the availability of a lock at the time of query may not be the availability of a lock at a later time. The SELECT is a snapshot; it does not dynamically change the status of records selected, especially where the value of a function would have to be continuously updated against each record of mytable, and this is inherently not Rushmore-optimizable. It's be very expensive in terms of system overhead,netowrk traffic and server load if this were not the case...