U++ forum: Welcome to the forum

Search on this site

Search in forums

Home » U++ Library support » U++ SQL » SQLite On delete cascade .sch ?

Sun, 30 June 2019 22:00

Xemuth
Messages: 387
Registered: August 2018
Location: France

Senior Member

Changing the foreign_keys setting affects the execution of all statements prepared using the database connection...

Also
Quote:

As of SQLite version 3.6.19, the default setting for foreign key enforcement is OFF. However, that might change in a future release of SQLite.

Seems like having it enable do not having disadvantages.

Quote:

(Maybe as compromise, we can just add method to Sqlite3Session that enables them?)

Yeah I think it's the best compromise to do. I Will try to implement it.

Best Regard.
Xemuth

		SQLite On delete cascade .sch ? By: Xemuth on Wed, 26 June 2019 20:30
		Re: SQLite On delete cascade .sch ? By: mirek on Thu, 27 June 2019 08:28
		Re: SQLite On delete cascade .sch ? By: Xemuth on Thu, 27 June 2019 10:55
		Re: SQLite On delete cascade .sch ? By: Xemuth on Thu, 27 June 2019 20:55
		Re: SQLite On delete cascade .sch ? By: mirek on Fri, 28 June 2019 08:02
		Re: SQLite On delete cascade .sch ? By: Xemuth on Fri, 28 June 2019 12:23
		Re: SQLite On delete cascade .sch ? By: Xemuth on Fri, 28 June 2019 18:51
		Re: SQLite On delete cascade .sch ? By: Xemuth on Fri, 28 June 2019 20:38
		Re: SQLite On delete cascade .sch ? By: Xemuth on Fri, 28 June 2019 21:23
		Re: SQLite On delete cascade .sch ? By: mirek on Sun, 30 June 2019 19:18
		Re: SQLite On delete cascade .sch ? By: Xemuth on Sun, 30 June 2019 22:00

Previous Topic:	Sqlite join from select
Next Topic:	Multiple DUAL_UNIQUE generate conflicting statements

Goto Forum:

] [

]

Current Time: Fri May 10 11:34:52 CEST 2024

Total time taken to generate the page: 0.01874 seconds