>When you say "scans a table", are you using a scan/endscan loop or doing a REPLACE ALL FOR ... (another way to scan the table for records that match the criteria) ?? If you are doing a REPLACE ALL, the ALL keyword will implicitly lock the table (loose the ALL, and no LOCK). To avoid this, set an index (or create a temporary one). SEEK for the first matching record and if found, do your REPLACE to the REST while the HAVING criteria remains True.
>

Gary,

The existing program does SCAN..ENDSCAN but needs to be optimised. A number of problems - there is no index and it cannot be opened exclusive to create one, and SELECT * WHERE RECNO()>nnn does not work fast enough. It starts at the first record and will take too long. Existing program calculates start position, verifies data in start position and does SCAN REST. We are having problems with tables being locked and it seems to coincide with this procedure. The table is open shared but as soon as the first replace within the scan hits, others have problems adding records to end of table.