Re: Multilevel inserts issue with ODBC

Hi Krishnanand,

I have done multi-level inserts (up to several thousand rows) from a
VB.NET application using the psqlODBC driver - various versions - on XP,
Win 7, and Win 10.

Hope this helps,
George/
/
On 22/06/2016 4: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?
>
> 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
>
> *<mailto:krishnanand(dot)pandey(at)accenture(dot)com>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,
> <mailto:krishnanand(dot)pandey(at)accenture(dot)com>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