O$8.0.3 plus Postgres 9.3 and 9.1

[Grzegorz (Greg) Pasternak]

Just out of curiosity, what did you do to make it work?


On Sep 8, 2017, at 10:22 PM, Mike Rowan <michael.rowan3 at gmail.com> wrote:

> As always, my thanks to all for this information.  I still don't understand
> the difference between @[...] in the SELECT,  and @[...] in the WHERE.
> 
> I'm not sure the manual explains it.
> 
> Anyway, I am up and running. for now.  Ta all.
> 
> On Fri, Sep 8, 2017 at 11:29 PM, Doug Easterbrook <doug at artsman.com> wrote:
> 
>> so.. what is in #S1.    probably not a field name
>> 
>> Doug Easterbrook
>> Arts Management Systems Ltd.
>> mailto:doug at artsman.com
>> http://www.artsman.com
>> Phone (403) 650-1978
>> 
>>> On Sep 7, 2017, at 7:50 PM, Mike Rowan <michael.rowan3 at gmail.com> wrote:
>>> 
>>> Good point Greg.  In my app however, ALL column names are unique, so that
>>> is a problem that has never arisen.
>>> 
>>> Cheers and thanks for the interest.
>>> 
>>> On Fri, Sep 8, 2017 at 11:12 AM, Grzegorz (Greg) Pasternak <
>>> grzegorz at myfastcom.ca> wrote:
>>> 
>>>> 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
>>>>> 
>>>> 
>>>> _____________________________________________________________
>>>> Manage your list subscriptions at http://lists.omnis-dev.com
>>>> 
>>> _____________________________________________________________
>>> Manage your list subscriptions at http://lists.omnis-dev.com
>> 
>> 
>> _____________________________________________________________
>> Manage your list subscriptions at http://lists.omnis-dev.com
>> 
>> 
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
>