Re: Multilevel inserts issue with ODBC

On 06/21/2016 01:37 AM, 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