O$8.0.3 plus Postgres 9.3 and 9.1
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
_____________________________________________________________
Manage your list subscriptions at lists.omnis-dev.com