>Hi,
>
>I see you solved the slow SQL but this wouldn't have worked anyway:
>

>select c_memo
>scan for updflag = 'U'
>  select bsmemo
>  if seek(c_memo.k_seqno)
>    replace textln with c_memo.textln
>  endif
>endscan
>

>since you're not re-selecting c_memo after the replace....
>
>Regards,
>Viv

Viv,

I believe there's an undocumented feature that the endscan re-selects the alias of the scan