Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Foreign Key] PRAGMA db call does not work #20

Open
biomade opened this issue Jul 6, 2017 · 6 comments
Open

[Foreign Key] PRAGMA db call does not work #20

biomade opened this issue Jul 6, 2017 · 6 comments

Comments

@biomade
Copy link

biomade commented Jul 6, 2017

Per you instruction, I tried
basel.database.run("PRAGMA foreign_keys = ON");

I put it in the app.config and it did not work
I tried it in the controller - when the controller loads and also in a function call and both did not work

@jayralencar
Copy link
Contributor

It should work.

@biomade
Copy link
Author

biomade commented Jul 7, 2017

I know it should BUT IT DOES NOT. Have you tried it?

@jayralencar
Copy link
Contributor

jayralencar commented Jul 7, 2017

Yes, I use it in a project, and works fine.

@biomade
Copy link
Author

biomade commented Jul 8, 2017

Can you point me to a repo that I could pull down so I can see how you are implementing it?

@jayralencar
Copy link
Contributor

@biomade
Copy link
Author

biomade commented Jul 8, 2017

That is a DB call. I am trying set the foreign_keys = ON.
I know this works from the sqlite-sync sqlite.js files bit it does not work from a controller in the application itself. Please try this and you will see it does not work

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants