Hi All,

Went crazy with a REPLACE problem until I realized I was being bitten by an old problem. Thought I would post what was happening FYI:

Assume two tables, invheader and invdetail. invheader has 1 record and invdetail has none. The following statement won't work:

SELECT invdetail
REPLACE invheader.invno WITH "00001"

No replacement is made because the current alias, invdetail, is at EOF() (no records), even though invheader has a record and this is a valid statement. The following WILL work:

SELECT invheader
REPLACE invheader.invno WITH "00001"

Sometime this won't be as obvious as you won't have a SELECT statement to make the ALIAS() apparent.