|
FOREIGN KEY constraint failed
|
|
Dec-04-2020, 07:27 AM
(This post was last modified: Dec-04-2020, 07:28 AM by Gribouillis.)
Insert the departments and the locations before the query to insert the employees and it will work. The queries fail because they use foreign IDs that don't exist yet in the database.
|
|
|
| Messages In This Thread |
|
FOREIGN KEY constraint failed - by SalsaBeanDip - Dec-04-2020, 12:48 AM
RE: FOREIGN KEY constraint failed - by Gribouillis - Dec-04-2020, 07:27 AM
RE: FOREIGN KEY constraint failed - by SalsaBeanDip - Dec-05-2020, 10:22 PM
|
| Possibly Related Threads… | |||||
| Thread | Author | Replies | Views | Last Post | |
| SQLite Unique constraint failed error | djwilson0495 | 3 | 17,397 |
Aug-14-2020, 05:23 PM Last Post: ndc85430 |
|
| length constraint on phrase hash to password | javaben | 0 | 2,582 |
Aug-21-2019, 05:34 PM Last Post: javaben |
|
| [split] create a virtual keyboard of an unknown foreign language with python | fakoly | 0 | 3,078 |
May-28-2018, 01:34 AM Last Post: fakoly |
|
| sqlite3 foreign key | dsvinson | 2 | 6,076 |
Mar-31-2018, 04:43 PM Last Post: woooee |
|
