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