U++ framework: U++ SQL » SQLite and foreign keys

Home » U++ Library support » U++ SQL » SQLite and foreign keys

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: SQLite and foreign keys [message #41292 is a reply to message #40977]

Mon, 25 November 2013 20:05

mirek
Messages: 14291
Registered: November 2005

Ultimate Member

wimpie wrote on Wed, 16 October 2013 20:28

Hello,

I am using SQLite, with a Schema with a few tables with references and I noticed I could delete rows in one table which were used in another.
After some digging I noticed in Sqlite3Schema.h the REFERENCES*** macro's are not defined.

First I wondered why, but after reading Sqlite doc's I think it's because it doesn't allow adding constraints to an existing table. Am I right?

Actually, it is rather because nobody bothered so far to implement it Smile

In fact, the issue is in RM for 2 years already:

http://www.ultimatepp.org/redmine/issues/172

I did not know there is problem with adding references later, if that is true, it really is kind of problem...

Mirek

Report message to a moderator

[Message index]

		SQLite and foreign keys By: wimpie on Thu, 17 October 2013 02:28
		Re: SQLite and foreign keys By: chickenk on Thu, 17 October 2013 10:13
		Re: SQLite and foreign keys By: chickenk on Thu, 17 October 2013 10:20
		Re: SQLite and foreign keys By: wimpie on Thu, 17 October 2013 10:33
		Re: SQLite and foreign keys By: mirek on Mon, 25 November 2013 20:05

Previous Topic:	Strange build error with OleDB
Next Topic:	testing out firebird in bazaar missing ibase.h

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu May 14 02:40:59 GMT+2 2026

Total time taken to generate the page: 0.00511 seconds