Hi,

I would like to download shipment data and has text at header. i created a query.
when i used whinh430.text it not display full. only 10string.

So i try to use this code;

declaration:

domain tttxt.buf text
table twhinh430

detail.1:
before.layout:
select tttxt010.*
from tttxt010
where tttxt010._index1=whinh430.text
selectdo
text=tttxt010.text
selectempty
text=""
endselect


but has error Unknown column 'whinh430.text' (error 302)
Please help.
Your help is much appreciated.

Hi,

i found the code from the thread, i follow this and it's working.



#include <bic_text>

string stxt(3256)
string sbuf(80,40)
long ftxt
long i

before.program:


detail.1:
before.layout:
stxt = ""
if whinh430.text <> 0 then
for i = 1 to text.to.buf("whinh430.text", language$, 40, sbuf)
stxt = strip$(stxt) & " " & strip$(sbuf(1,i))
endfor
endif