U++ forum: Welcome to the forum

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

Thu, 27 June 2019 20:55

Xemuth
Messages: 387
Registered: August 2018
Location: France

Senior Member

Well ,

According to stack overflow/Sqlite documentation, sqlite table cannot be altered after creation.
Since PGSQL alter table to add reference constraint, it do not work on sqlite.

Here is how we create a reference in SQLite :

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
);

So I had try something like that :

#ifndef REFERENCES
#define REFERENCES(x) 		      ATTRIBUTE("FOREIGN KEY(@c) REFERENCES (@x) ON DELETE CASCADE,","");
#endif

#ifndef REFERENCES_CASCADE
#define REFERENCES_CASCADE(x) 	      ATTRIBUTE("FOREIGN KEY(@c) REFERENCES (@x) ON DELETE CASCADE,","");
#endif

#ifndef REFERENCES_
#define REFERENCES_(n, x)	      ATTRIBUTE("FOREIGN KEY(@c) REFERENCES " #n "(@x) ON DELETE CASCADE,","");
#endif

#ifndef REFERENCES_CASCADE_
#define REFERENCES_CASCADE_(n, x)    ATTRIBUTE("FOREIGN KEY(@c) REFERENCES " #n "(@x) ON DELETE CASCADE,","");
#endif

But Seems not working, moreover my bad knowledge of Upp SQL does not really help.

Have you any idea ?

Thanks in advance
Best Regard

Report message to a moderator