Unable to insert in database

Hello.

I am creating an sql insert command in Corona. It fails with a constraint error (#19). What’s odd is that if I copy the command and run it in a database tool (Valentina Studio), it works fine.

Any clues welcome.

-Bob

The DB needs to be in the documents directory.

If you’re trying to modify a DB in the Resource directory it will fail as that space is Read-Only.

Thank you for responding.

Database is in documents directory.

The DB needs to be in the documents directory.

If you’re trying to modify a DB in the Resource directory it will fail as that space is Read-Only.

Thank you for responding.

Database is in documents directory.