fix Foreign Key constraint in this SQLite3 database?
I’m creating a table of people, and I want to record a table of productions, with the amount each person contributed to that production. So we have a table of share splits; each production earns an amount of shares referenced by a splitid, and each split id covers a number of rows saying how many shares each person gets.
fix Foreign Key constraint in this SQLite3 database?
I’m creating a table of people, and I want to record a table of productions, with the amount each person contributed to that production. So we have a table of share splits; each production earns an amount of shares referenced by a splitid, and each split id covers a number of rows saying how many shares each person gets.
Please help me fix my Foreign Key constraint in this SQLite3 database?
This is (hopefully) a dumb question, but it’s been an age since I last did any SQL and my supposedly simple one-to-many relationship is erroring in a way that I don’t understand.
“PRAGMA foreign_keys = ON;” added, but Foregn key dosen’t work properly in SQLite
Colleague, I have small database and C++ program with sqlite3 library.
There are several table with connection by Foreign key: