Page 1 of 1

ExecuteNonQuery returns -1 for SqlServer and 0 for MySql

Posted: Fri 15 Aug 2014 14:45
by idem84
Hi
I have a question for specific commandtexts ("truncate table" detected) and different providers result in ExecuteNonQuery...

Sample code:

...
uniCommand.CommandText="truncate table anytable"
var res = uniCommand.ExecuteNonQuery(); //Works ok, but return value of -1 if provider is SqlServer; and returns 0 if provider is MySql
...

Thanks in advance

Re: ExecuteNonQuery returns -1 for SqlServer and 0 for MySql

Posted: Mon 18 Aug 2014 10:51
by Pinturiccio
We have reproduced the issue. We will investigate it and post here about the results as soon as possible.

Re: ExecuteNonQuery returns -1 for SqlServer and 0 for MySql

Posted: Wed 03 Sep 2014 12:35
by Pinturiccio
We have fixed the bug with returning 0 instead of -1 for all statements except UPDATE, DELETE, INSERT statements with MySQL. We will post here when the corresponding build of dotConnect Universal is available for download.

Re: ExecuteNonQuery returns -1 for SqlServer and 0 for MySql

Posted: Thu 04 Sep 2014 14:14
by Pinturiccio
New build of dotConnect Universal 3.50.736 is available for download now!
It can be downloaded from http://www.devart.com/dotconnect/univer ... nload.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?t=30320