Yes Replace For still locks the table. Use Update - SQL and each individual record will be locked as it is updated. No file lock.
HTH.
>Hi All,
>
> An App that I'm working on has a requirement to Merge Company and Contact Records. I was thinking of doing something like:
>
>
SELECT contacts
>
>REPLACE companyid WITH nNewCompanyId ;
> FOR companyid = nOldCompanyId
>
>What I'm concerned with is that in FPW2.6 issuing a REPLACE with a FOR Clause would lock the Table ( Effectively that same as issuing an FLOCK() ), does anyone know if the same problem exists with VFP6.0? Any suggestions or different thoughts on ways to achieve the update would be appreciated.
>
>Thanks,
>Gavin...
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao