>>>>>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.
Edward Pikman
Independent Consultant