Like most of us, I'm sure, we have times when we need to lock a large number of records at one time. In this case we need to mark over 100 records before batching them.

On a whim we just tried this SQL statement and darned if it didn't work. This is all VFP 9 by the way, both code and .DBF.

My question is this, has anyone else used this (I have never seen it before) and what what are the odds that it can always be relied on to work? It just seems to be too easy.

SET MULTILOCKS ON

select k_arinvc, rlock('arinvc') as lockok ;
from arinvc ;
where duedt > {^2007-02-01} ;
into cursor c_locks

brow