View Single Post
  #2  
Old 10th July 2019, 17:57
Ajesh's Avatar
Ajesh Ajesh is offline
Guru
 
Join Date: Feb 2009
Posts: 648
Ajesh is on a distinguished road
Baan: LN 10.4 - DB: Oracle - OS: HP-Unix
try doing something like

Code:
query.extend.where.in.zoom( "tcemm170.comp in (select tfgld003.bcmp from tfgld003 where tfgld003.indt = 0 )" )
Is there a need to use get.compnr() as by default the table would look in the current company?
Reply With Quote