>>>Thanks Nadya. I got the following message "Alias REFDOCSADDY is not found". This is a table in the same directory that all other tables are located in. What should I consider? Thanks again.
>>
>>Open the second table in 0 before appending.
>
>Nadya,
>
>I don't think it would evaluate the for condition for each record if he did that. I think it will do the comparison on current record in the new work area. IOW, if the current record causes the FOR clause to evaluate to true, ALL of the records will be appended from the table. Otherwise, none will be appended.
>
>APPEND FROM opens the table by itself; he should leave off the alias in the FOR clause.
Thanks, Steve. Didn't realize, that we left alias in the FOR condition. It should be removed from this condition, as you showed.
If it's not broken, fix it until it is.
My Blog