O$8.0.3 plus Postgres 9.3 and 9.1

Mike Rowan michael.rowan3 at gmail.com
Thu Sep 7 21:37:51 EDT 2017


The following slightly simplified query in which iCol1, iCol5 are as
follows:

iCol1 integer 64 bit
iCol5 character simple char 1

-----------------------------------------------------------------
SELECT @[iCol1] AS ref, @[#S1], @[iCol5]
FROM company, branch, purchaseorder
LEFT JOIN contact ON (ct_id = po_ct_id)

WHERE
co_id = br_co_id
AND br_id = po_br_id
AND po_invoice_nr >= 10000000
AND po_invoice_nr <= 10000100 AND ((po_type = 1) OR (po_type = 3))
ORDER BY po_invoice_nr
LIMIT 20000
----------------------------------------------------------
results in this Error message:

ERROR: could not determine data type of parameter $2

As I am fairly new to SQL I'm not sure what is wrong.  If I omit all terms
in the SELECT line except the first, there is no error.  Any second or more
term results in the same error.

Anyone got a minute for this one?

Mike



More information about the omnisdev-en mailing list