Welcome Guest, Not a member yet? Register   Sign In
sqlsrv/pdo massive update fails
#1

Hi,

I'm using CI 3.0.5 with a SQL Server 2008 database and the sqlsrv driver. When I try to execute from a CI model some write query affecting many rows to a specific table it doesn't do nothing.

Examples:
- $this->db->insert_batch('GT_CalendariProfessional', $data); where $data have arround 200 rows.
- $this->db->where_in("CalendariProfessionalId", $ids)->update("GT_CalendariProfessional", array($data); where $ids have arround 200 rows.

If I output the generated SQL (last_query()) and execute this directly to the database it works as expected.

Some background:
- The table have a trigger. If I disable the trigger the SQL works again.
- The same happened with CI 3.0.3
- The same happens using pdo driver.

Is it a bug?
Reply




Theme © iAndrew 2016 - Forum software by © MyBB