Hi,

I would like to consult one question :

select tfacp200.suno
from tfacp200
where tfacp200._index1 inrange {:ttyp.f, :ninv.f}
and {:ttyp.t, :ninv.t}
order by tfacp200._index1
selectdo
select tccom001.emno, tccom001.nama
from tccom001
where tccom001._index1 = {:tfacp200.suno} ?????
...
endselect

pls tell me how to conver tfacp200.suno to number type, because
tccom001._index1 is field emno with type Long, tfacp200.suno field type is Str6 ?

thanks a lot

Rgds,
Paul

in addition you will have to put the resulting long into a variable.

for example:


long supplier.number

select tfacp200.suno
from tfacp200
where tfacp200._index1 inrange {:ttyp.f, :ninv.f}
and {:ttyp.t, :ninv.t}
order by tfacp200._index1
selectdo

supplier.number = lval(tfacp200.suno)

select tccom001.emno, tccom001.nama
from tccom001
where tccom001._index1 = {:supplier.number}
...
endselect

Hi Paul,Evertsen,

thank you very much.
I should revise my question is 'converting to number', got your answer, they are useful for your reply as my session work when I use lval(string_expr) in program script.