Re: Multilevel inserts issue with ODBC
От | Adrian Klaver |
---|---|
Тема | Re: Multilevel inserts issue with ODBC |
Дата | |
Msg-id | f7f5db21-e72b-c365-e61e-3ac7ce0cda23@aklaver.com обсуждение исходный текст |
Ответ на | Multilevel inserts issue with ODBC (<krishnanand.pandey@accenture.com>) |
Список | pgsql-odbc |
On 06/22/2016 02:20 AM, krishnanand.pandey@accenture.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.png@01D05501.1577B7C0 > Newcastle Delivery Centre ** > > UK Delivery Centre > (Newcastle) > > 15A | 1 Quick Silver Way | Cobalt Business Park |Tyne and Wear| NE27 0QQ > > * krishnanand.pandey@accenture.com <mailto:krishnanand.pandey@accenture.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.klaver@aklaver.com] > Sent: 21 June 2016 21:57 > To: Pandey, Krishnanand <krishnanand.pandey@accenture.com>; > pgsql-odbc@postgresql.org > Subject: Re: [ODBC] Multilevel inserts issue with ODBC > > > > On 06/21/2016 01:37 AM, krishnanand.pandey@accenture.com > <mailto:krishnanand.pandey@accenture.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@production=# select * from odbc_test ; > > id | fld_1 > > ----+------- > > 1 | one > > 2 | two > > 3 | three > > (3 rows) > > > > > >> > >> > >> > >> Thanks > >> > >> > >> > >> > >> > >> > >> > >> /Krishnanand Pandey/ > >> > > > > > > > > -- > > Adrian Klaver > > adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.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.klaver@aklaver.com
В списке pgsql-odbc по дате отправления: