Re: Return codes on PDO insert

Paul,

I think what you are looking for is 
https://www.php.net/manual/en/pdo.setattribute.php

Specifically PDO::ATTR_ERRMODE.

Or are you saying that PDO::errorCode() had no errors?

On 3/25/21 1:51 PM, Paul M Foster wrote:
> I'm using a database class which wraps around the PDO classes, using a
> SQLite3 database. I wrote some PHP to insert a record, and it didn't
> insert, but no error was issued. Turns out I violated a constraint on the
> table-- I'd left a field blank, and the column had a NOT NULL constraint.
>
> I fixed the code to fill in that field. But I can't figure out why PDO
> doesn't throw an error code when an insert fails due to a failed
> constraint. I deliberately wrote some code to violate the constraint, and
> inserted some code into the database class to dump out with whatever code
> was returned from the execute() call. A failed insert yielded a 0000 code
> (no error). So it's not my class.
>
> Am I missing something? I would think the PDO driver would issue a (bad)
> error code on a failed (constraint) insert. Is this not expected behavior?
> Or is the SQLite3 back end at fault for not issuing an error?
>
> Paul
>