O$8.0.3 plus Postgres 9.3 and 9.1

[Grzegorz (Greg) Pasternak]

Mike;

Just a quick comment, I would advise to always fully qualify column names in your LEFT JOIN clause to avoid any ambiguity and consequently errors.

Greg


On Sep 7, 2017, at 9:37 PM, Mike Rowan <michael.rowan3 at gmail.com> wrote:

> 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 http://lists.omnis-dev.com
>