Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

@Tyler I don't have any experience with SQLite but found this post (click here) and a few others like it referring to Enable Foreign Key Support. It seems it may be off as a default and may need to be turned on. See "2. Enabling Foreign Key Support " in the post.

@Tyler I don't have any experience with SQLite but found this post (click here) and a few others like it referring to Enable Foreign Key Support. It seems it may be off as a default and may need to be turned on. See "2. Enabling Foreign Key Support " in the post.

Edit (9/11/16):

Could not help much without the actual software so decided to install. Worst to get working without a doubt (have HSQLDB server, MySQL server, and PostgreSQL server). It certainly has limited capabilities. Except for testing (and maybe portability) not worth it in my book.

There are multiple things to adhere to. LO will NOT let you set up relations. That doesn't mean it won't honor them. Quite a bit of net searching and trial and error (even went so far as to completely compile SQLite) led me to these results. The tool I found most useful was DB Browser for SQLite (Synaptic Package Manager - sqlitebrowser). After many pages, I remembered seeing (can't locate it again) where Foreign Keys setting needed to be set when CREATING the DB. So - created new DB with it on. Still no luck in LO but now the setting was on (couldn't seem to change the setting in originally created DB). Next, again using DB Browser set up two tables with data. Visible/accessible in LO - OK! Created Foreign Key using DB Browser and tested with the two tables - got FOREIGN KEY constraint failed when appropriate - OK, foreign keys can be set. Went back to LO and tried same thing - got this result:

image description

To me this means you can have foreign keys honored in LO but just can't set them up within LO ( or see them using Tools->Relationships).