Hi Friends,

I am working with LN 6.1 FP 3.

I have a session and in a field I need to filter by certain criterion then I have the following Baan code with Informix.

field.grid.f:
when.field.changes:
grid.t = grid.f
selection.filter:
import("cpla.f", parent.cpla)
hold.groups = ticpedll0004.get.sfc.seri.group(cpla.f)
if isspace(hold.groups) then
query.extend.where.in.zoom("tisfc350.grid(1;3) = '' ")
else
query.extend.where.in.zoom("tisfc350.grid(1;3) in (" & hold.groups & ")")
endif


On informix I don't have problem with query.extend but We send to customer and I get various errors at level of Oracle.

I attach you the logs log.oracle8 and log.bshell.

Anybody can tell me what should I do?

Thank you.

Logfile says that the failing query is in log.ora.sql. Can you attach that one as well?

Logfile says that the failing query is in log.ora.sql. Can you attach that one as well?
Thank you friend,

Of course,

Attach you the log.ora.sql.


Thank you a lot.

Nothing strange to be seen in generated query. Did you try the query with qptool6.2?

What version of Oracle?

Actually thinking of this http://www.dba-oracle.com/sf_ora_00907_missing_right_parenthesis.htm