Re: Multilevel inserts issue with ODBC

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