>>>>>>Can someone help me with the syntax with REPLACE.
>>>>>>
>>>>>>REPLACE mytable.myfield with cSomething
>>>>>>or
>>>>>>REPLACE mytable.myfield with cSomething in mytable
>>>>>>or
>>>>>>REPLACE mytable.myfield with cSomething in "mytable"
>>>>>>
>>>>>>Tks
>>>>>>Mike
>>>>>
>>>>>Use transparent syntax:
>>>>>Select mytable
>>>>>Replace mytable.myfield with cSomething
>>>>Hi Ed,
>>>>Do you have to select the table if you reference the field with the table alias as in mytable.myfield?
>>>>Mike
>>>
>>>Actually not! But writing one more line of code you get clear readable syntax.
>>I guess by the same token you don't need the 'in mytable clause' at the end if you do either of the above. I ask because in some of my code the replace does not seem to be very reliable.. sometimes it does and sometimes it doesn't.
>>I have also had trouble with APPEND BLANK. I issued APPEND BLANK and replaced the code, and then issued a second APPEND BLANK. It failed on a violation of the primary index because the replace did not take place. By putting th 'in mytable' clause in it seemed to work. Any ideas?
>>Mike
>
>If you don't make mytable active area (Select..) you must use 'in mytable' clause.

Hang on a minute! You just said that I don't actually need to do that if I use the mytable.myfield syntax (the fact that you don't like this particular syntax is noted :)
Mike