View Single Post
  #2  
Old 05-03-2014, 12:05 AM
JohnnyChimpo JohnnyChimpo is offline
Registered User
JohnnyChimpo's Avatar
Join Date: Jun 2004
Posts: 105
JohnnyChimpo is on a distinguished road
I am trying to get sqlite foreign key functionality working on my server. Basically i have a bunch of tables with some id as a primary key, and i am referencing them in another table, with the rules on delete cascade and on update cascade. However when i make the query the rules do not work. Im not sure how requestsql function is being abstracted but usually you can just do query ("pragma foreign_keys=1"); query("delete blah blah") query.commit. That does not work, and id like some insight.
Reply With Quote