O$8.0.3 plus Postgres 9.3 and 9.1
Just out of curiosity, what did you do to make it work?
On Sep 8, 2017, at 10:22 PM, Mike Rowan <michael.rowan3@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@artsman.com> wrote:
>
>> so.. what is in #S1. probably not a field name
>>
>> Doug Easterbrook
>> Arts Management Systems Ltd.
>> mailto:doug@artsman.com
>> www.artsman.com
>> Phone (403) 650-1978
>>
>>> On Sep 7, 2017, at 7:50 PM, Mike Rowan <michael.rowan3@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@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@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 lists.omnis-dev.com
>>>>>
>>>>
>>>> _____________________________________________________________
>>>> Manage your list subscriptions at lists.omnis-dev.com
>>>>
>>> _____________________________________________________________
>>> Manage your list subscriptions at lists.omnis-dev.com
>>
>>
>> _____________________________________________________________
>> Manage your list subscriptions at lists.omnis-dev.com
>>
>>
> _____________________________________________________________
> Manage your list subscriptions at lists.omnis-dev.com
>
_____________________________________________________________
Manage your list subscriptions at lists.omnis-dev.com