>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