Hi,

Want to ask how to write a script to link the purchase lines text file.

the purchase order lines (tdpur041.txta) and text manager (tttxt010.ctxt)

regards.

select tttxt010.text
from tttxt010
where ttxt010._index1 = {:tdpur401.txta}
selectdo
endselect

This way u can have the text linked to PO line in ttxt010.text field.

hope i have solved ur query.......

Hi, This script is ok, but tttxt010.ctxt field text is too long and have buffer. how i design on my report?

Not sure why everyone is running around trying to join to tttxt010. All you need to do to get the the two fields off of tdpur041. Like this

select tdpur041.orno, tdpur041.txta
from tdpur041
where ......


Then add tdpur041.txta on the report input fields as tctxtn. Then just put the field in your layout. No reason to join to tttxt010 table. And if for some reason you want to print the text 1 line at a time, then use text.to.buf.

Thanks. that is work