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