Without ALL it randomly misses to REPLACE the logical value with .T., though the percentage is very low 2% say. But as the records are not registered=.t. they get deleted next time round (my logic) messing up the whole data integrity.

SEEK m.id
REPLACE dbf.registered WITH .T. WHILE dbf.id = m.id

>>Hi All
>>
>>I have these lines:
>>
>>

SEEK m.id
>>REPLACE ... WITH ... WHILE dbf.id = m.id

>>
>>Is this okay cause at time I have found it to fail. Is the failure my otherwise problem or this command problem. Is ALL required as below?
>>
>>

SEEK m.id
>>REPLACE ALL ... WITH ... WHILE dbf.id = m.id

>>
>>Please advise
>
>I think ALL would take you back to the beginning of the file. How exactly does "it fail"?