[sqlite] sqlite 3.8.2 foreign key issue

You are always welcome. SQLite is not strongly typed - you are very welcome to store an integer in a text field (in fact it results in only using the data associated with the smallest integer internal type that can hold the value, so a clear advantage in the embedded world). You are also welcom

[sqlite] sqlite 3.8.2 foreign key issue

Thanks for the help. Adding a trailing underscore helped also. I'm still wondering why insertion worked at all because defining oid as column name with the type VARCHAR should result in an error on execution. > > > On 2015-04-09 12:00 AM, Gustav Melno wrote: >> The example below is s subset of m

[sqlite] sqlite 3.8.2 foreign key issue

On 9 Apr 2015, at 6:04pm, Gustav Melno wrote: > Thanks for the help. Adding a trailing underscore helped also. I'm still > wondering why insertion worked at all because defining oid as column name > with the type VARCHAR should result in an error on execution. The three names for the integer

[sqlite] sqlite 3.8.2 foreign key issue

On 2015-04-09 12:00 AM, Gustav Melno wrote: > The example below is s subset of my ical storage database which has > problems with foreign keys. Although I tried a lot I couldn't figure > out why the foreign key doesn't work. I took the example from the > documentation and compared to my two ta

[sqlite] sqlite 3.8.2 foreign key issue

The example below is s subset of my ical storage database which has problems with foreign keys. Although I tried a lot I couldn't figure out why the foreign key doesn't work. I took the example from the documentation and compared to my two tables, there is no major difference or I don't see the