U++ forum: Welcome to the forum

Re: SQLite On delete cascade .sch ? [message #51969 is a reply to message #51958]

Fri, 28 June 2019 12:23

Xemuth
Messages: 387
Registered: August 2018
Location: France

Senior Member

Quote:

Maybe try with INLINE_ATTRIBUTE ?

I had try but SQLite do not accept this kind of thing :

CREATE TABLE "OW_EQUIPES_PLAYERS" (
	"EP_EQUIPE_ID"	integer FOREIGN KEY("EP_EQUIPE_ID") REFERENCES "OW_EQUIPES"("EQUIPE_ID") ON DELETE CASCADE,
	"EP_PLAYER_ID"	integer FOREIGN KEY("EP_PLAYER_ID") REFERENCES "OW_PLAYERS"("PLAYER_ID") ON DELETE CASCADE,
);

Quote:

Anyway, if it cannot be altered after creation, then there will be situation where doing it will be impossible, like two tables referencing each other - because one of them will not exist during creation.

It make sense for real SGBD but SQLite seems to don't care. I have been able to create my first table with this code :

CREATE TABLE "OW_EQUIPES_PLAYERS" (
	"EP_EQUIPE_ID"	integer,
	"EP_PLAYER_ID"	integer,
	FOREIGN KEY("EP_EQUIPE_ID") REFERENCES "OW_EQUIPES"("EQUIPE_ID") ON DELETE CASCADE,
	FOREIGN KEY("EP_PLAYER_ID") REFERENCES "OW_PLAYERS"("PLAYER_ID") ON DELETE CASCADE
);

Isn't there a keyword in .sch like INLINE ATTRIBUTE/ Attribute that force the add of instruction "foreign key(..."
at the end of table definition ?
Or a way to force "free text" in sch file ?

Best Regard

Xemuth

[Updated on: Fri, 28 June 2019 18:11]

Report message to a moderator