vaishali_sftdev
17th February 2010, 12:43
Dear All,

I have following subquery in query.extension:

querystring = " tdcor130.cont in (select htgtm001.cjcn from htgtm001 where bdat <= date.t and htgtm001._index1= {tdcor130.cont,tdcor130.odrn}) "

But it is throwing error: syntax error in expression where (). Please tell how can I correct it.

Reply ASAP.
grzegorz
17th February 2010, 13:14
Assuming, that bdat is a field in htgtm001 table, and date.t is an external variable, I would suggest:

querystring = " tdcor130.cont in (select htgtm001.cjcn from htgtm001 where htgtm001.bdat <= :date.t and htgtm001._index1= {tdcor130.cont,tdcor130.odrn}) "
bdittmar
17th February 2010, 13:39
Dear All,

I have following subquery in query.extension:

querystring = " tdcor130.cont in (select htgtm001.cjcn from htgtm001 where bdat <= date.t and htgtm001._index1= {tdcor130.cont,tdcor130.odrn}) "

But it is throwing error: syntax error in expression where (). Please tell how can I correct it.

Reply ASAP.

Hello,

._index1 = {:field1, :field2}

Regards