By design, the xBase REPLACE statement is scoped to the current alias, so if it's at EOF, no replaces will occur. This is why it sometimes works and sometimes does not (it depends on the currently selected alias, not the alias you are replacing into). You might check if the currently selected alias (not the REPLACE alias) is at EOF() to see if that's the problem. Regardless, you can get around this by adding the IN clause to your REPLACE (as Nick Neklioudov suggested)


Like this:

REPLACE LastName WITH "Smith" IN Customer

rather than:

REPLACE customer.lastname WITH "Smith"

Chris Vesper

>>Andy, add
>>IN myAlias (TARGET in your case) to your REPLACE
>
>>Nick
>
>If you mean to include the name of the alias with the field name (i.e. REPLACE CUSTOMER.NAME WITH ...), I have that and it wouldn't save the data until the alias is selected prior to the REPLACE statement. I must be dong something wrong. :(