when I use that statement before program it works
-------------------------------------------------
query.extension="exists(select tdflk711.* from tdflk711 " &
"where tdflk711._index1={tdflk712.cono}" &
" and tdflk711.fmng=:tgflk410.emno)"

--------------------------------------------------
but it only brings frst part of the combined field. combined field consist of two field. tdflk712.cono and tdflk712.reqn and its name tdflk712.cmba

when I try it in that way to get the result I needed it gives error message

query.extension="exists(select tdflk711.* from tdflk711 " &
"where tdflk711._index1=COLOR=red]{tdflk712.cmba}" [/COLOR] &
" and tdflk711.fmng=:tgflk410.emno)" tdflk712.cmba


message -extern vat tdflk712.cmba not found

baan4c3
oracle 8
sinan kaygusuz

Try this:


query.extension="exists(select tdflk711.* from tdflk711 " &
"where tdflk711._index1={tdflk712.cono, tdflk712.reqn}" &
" and tdflk711.fmng=:tgflk410.emno)"