OmeLuuk
15th October 2012, 12:06
Hello,
I have the intention to make a multi-occ inputscreen with fields from several tables, using the Multi Table feature using the function sec.add.table(). One of the tables cause error 302.
It is a documented limitation that in a query.extend.where no combination of constants and columns is allowed.Error : SQLState 42I12: Combined reference operand must contain only constants or only columns (error 302) or in manual terms The <row value constructor> shall either directly contain column references of one table only or directly contain constants or parameters only.
In the following example the <row value constructor> contains both a constant and a column reference, which is not allowed.
{ 10, dbtst120.deptno } refers to dbtst180
Yet I want to refer to tcibd004 using an item column.name and fixed index.part1 and index.part2:query.extend.where(
"{:qe.citt,:qe.bpid,tcibd001.item} refers to tcibd004 unref clear",
EXTEND_APPEND) What options do I have to work around error 302?
I have the intention to make a multi-occ inputscreen with fields from several tables, using the Multi Table feature using the function sec.add.table(). One of the tables cause error 302.
It is a documented limitation that in a query.extend.where no combination of constants and columns is allowed.Error : SQLState 42I12: Combined reference operand must contain only constants or only columns (error 302) or in manual terms The <row value constructor> shall either directly contain column references of one table only or directly contain constants or parameters only.
In the following example the <row value constructor> contains both a constant and a column reference, which is not allowed.
{ 10, dbtst120.deptno } refers to dbtst180
Yet I want to refer to tcibd004 using an item column.name and fixed index.part1 and index.part2:query.extend.where(
"{:qe.citt,:qe.bpid,tcibd001.item} refers to tcibd004 unref clear",
EXTEND_APPEND) What options do I have to work around error 302?