>Hi everyone!
>
>We do have a "bizzzzare problem" with this command...
>
>ex: REPLACE tablename.fieldname WITH "TESTING"
>
> About 99.9% work pretty fine, but in some piece of code
> this command doesn't work. NO MESSAGE, NO ERROR, NOTHING and
> doesn't replace. (simple table, no buffering even with a CURSOR)
>
> if we do the same command (same place) like this
>
> znSELECT = SELECT()
> SELECT tablename
> REPLACE fieldname WITH "TESTING"
> SELECT (znSELECT)
>
> This porton work OK!
> Any clues ????
>
>
>Thank you all!
The 1%, you got, happens when you call REPLACE against another work area when active work area pointer stands on EOF(). To avoid this unpleasant situation you may have a habit either always SELECT correct work area before REPLACE, or by using IN clause of REPLACE command: REPLACE ... IN myworkarea
Edward Pikman
Independent Consultant