Re: how to do a batch insert by unixodbc at linux?

Hi,

On Mon, Jul 25, 2016 at 1:51 AM, =E5=AE=81=E9=9D=99 <[email protected]> wrot=
e:
> I'm sorry to trouble you,but i've a question trouble me for 9 days,can yo=
u lend me a hand?
>   I'm a c++ developer,now i need to transplant my code to linux.most of t=
he work has been done up to now.But after i compile those codes ok, when i =
test them, I found that, the codes do batch insert to mysql database lost d=
ata.
>  I use the codes in otlv4.h,
>  like this:
>  otl_stream o(10,"insert into test values (:itest<int>); ",db);
>   int i;
>   for (i =3D 1; i <=3D 20; ++i)
>   {
>    o << i;
>   }
>
>  but only 1 and 10 was inserted sucessfully, other integers lost....i deb=
ug the program, i found after the API SQLExecute running,
>  SQLRawCount only return 1,the same codes are running ok at windows OS,sh=
ould i modify some configration of mysql-connector or the codes is wrong?co=
uld you help me please?

Can you show more code - how do you insert the data?
Also, try to enable logging on the unixODBC level and see what failure
it reports, if any, and where.

Thank you.

-- 
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/myodbc