>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

No ALL is not needed. It might fail if you're changing the id field.
You can use 'for' in that case or update-sql :

REPLACE ... WITH ... FOR dbf.id = m.id

or :
update myTable set fieldname = value where id = m.id

Cetin