Re: Multilevel inserts issue with ODBC

On 06/22/2016 02:20 AM, krishnanand(dot)pandey(at)accenture(dot)com wrote:
> Hi Adrian
>
>
>
> Same thing I am trying in a Windows XP 64bit machine from VB application
> it fails with the error (3137Missing semicolon (;) at end of SQL
> statement.).
>
> And if the same multi-level insert statement from code executed from
> psql/pgadmin it works.
>
>
>
> Could you please check the below statement from Windows odbc?

I do not have a Windows machine to test with.

>
>
>
> Thanks
>
>
>
>
>
> /Krishnanand Pandey/
>
> cid:image001(dot)png(at)01D05501(dot)1577B7C0
> Newcastle Delivery Centre **
>
> UK Delivery Centre
> (Newcastle)
>
> 15A | 1 Quick Silver Way | Cobalt Business Park |Tyne and Wear| NE27 0QQ
>
> * krishnanand(dot)pandey(at)accenture(dot)com <mailto:krishnanand(dot)pandey(at)accenture(dot)com>
>
> Confidential
>
>
>
> /This message is for the designated recipient only and may contain
> confidential, privileged, proprietary, or otherwise private information.
> If you have received it in error, please notify the sender immediately
> and delete the original. Any other use of this email by you is
> prohibited./////
>
> /Communications with Accenture or any of its group companies (“Accenture
> Group”) including telephone calls and emails (including content), may be
> monitored by us for the purposes of security and the assessment of
> internal compliance with company policy. Accenture Group does not accept
> service by e-mail of court proceedings, other processes or formal
> notices of any kind. ///
>
> /Accenture means Accenture (UK) Limited (registered number 4757301),
> Accenture Services Limited (registered number 2633864), or Accenture HR
> Services Limited (registered number 3957974), all registered in England
> and Wales with registered addresses at 30 Fenchurch Street, London EC3M
> 3BD, as the case may be./
>
>
>
>
>
>
>
>
>
> -----Original Message-----
> From: Adrian Klaver [mailto:adrian(dot)klaver(at)aklaver(dot)com]
> Sent: 21 June 2016 21:57
> To: Pandey, Krishnanand <krishnanand(dot)pandey(at)accenture(dot)com>;
> pgsql-odbc(at)postgresql(dot)org
> Subject: Re: [ODBC] Multilevel inserts issue with ODBC
>
>
>
> On 06/21/2016 01:37 AM, krishnanand(dot)pandey(at)accenture(dot)com
> <mailto:krishnanand(dot)pandey(at)accenture(dot)com> wrote:
>
>> Hi Adrian
>
>>
>
>>
>
>>
>
>> We are seeing this error in the VB application logs where we have
>
>> captured the error with the Err.Number and Err.Description in the code.
>
>>
>
>> Are there any limitations in the ODBC driver that it cannot handle
>
>> multi-level inserts?
>
>
>
> Not that I can see. Just got a chance to compile 09.05.0300 on my Linux
> machine. Going through the isql utility of unixODBC:
>
>
>
> SQL> INSERT INTO odbc_test(id, fld_1) VALUES (1, 'one'), (2, 'two'), (3,
>
> 'three')
>
> SQLRowCount returns 3
>
>
>
>
>
> postgres(at)production=# select * from odbc_test ;
>
> id | fld_1
>
> ----+-------
>
> 1 | one
>
> 2 | two
>
> 3 | three
>
> (3 rows)
>
>
>
>
>
>>
>
>>
>
>>
>
>> Thanks
>
>>
>
>>
>
>>
>
>>
>
>>
>
>>
>
>>
>
>> /Krishnanand Pandey/
>
>>
>
>
>
>
>
>
>
> --
>
> Adrian Klaver
>
> adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>
>
> ------------------------------------------------------------------------
>
> This message is for the designated recipient only and may contain
> privileged, proprietary, or otherwise confidential information. If you
> have received it in error, please notify the sender immediately and
> delete the original. Any other use of the e-mail by you is prohibited.
> Where allowed by local law, electronic communications with Accenture and
> its affiliates, including e-mail and instant messaging (including
> content), may be scanned by our systems for the purposes of information
> security and assessment of internal compliance with Accenture policy.
> ______________________________________________________________________________________
>
> www.accenture.com

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com