Net.sf.jasperreports.engine.JRException:Error preparing statement for executing the query:
SELECT MAX (E.comno) as Comno,
MAX (E.comname) as Comname,
SUM (A.qty) as QTY,
SUM (A.csamt) as CSAMT,
D.docno as Doc70no
From Basplustock A, DOC70BF d,bascommain E
WHERE A.loctyp = 3
and a.doc70no = d.docno and D.comid = E.comid
and D.comid in {comids} and E.comno =?
GROUP by D.docno
At Net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createStatement (jrjdbcqueryexecuter.java:240)
At Net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource (jrjdbcqueryexecuter.java:131)
At Net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource (jrfilldataset.java:686)
Caused by:java.sql.SQLException: Unsupported SQL92 tag appears: 312:comids
At Oracle.jdbc.dbaccess.DBError.throwSqlException (dberror.java:134)
At Oracle.jdbc.dbaccess.DBError.throwSqlException (dberror.java:179)
At Oracle.jdbc.dbaccess.DBError.check_error (dberror.java:1130)
Workaround:
There is a problem with the SQL statement, a careful look at your SQL statements, this error is not worth the comids.