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...