U++ forum: Welcome to the forum

Re: Sqlite and DUAL_PRIMARY_KEY [message #46417 is a reply to message #45841]

Mon, 09 May 2016 12:34

busiek
Messages: 70
Registered: February 2011
Location: Poland

Member

However it works when you create tables. Here is my schema upgrading code:

	All_Tables(sch);
	if (sch.ScriptChanged(SqlSchema::SCHEMA))
		Sqlite3PerformScript(sch.Schema());
	if (sch.ScriptChanged(SqlSchema::UPGRADE))
		Sqlite3PerformScript(sch.Upgrade());
	if (sch.ScriptChanged(SqlSchema::ATTRIBUTES))
		Sqlite3PerformScript(sch.Attributes());
	if (sch.ScriptChanged(SqlSchema::CONFIG)) {
		Sqlite3PerformScript(sch.ConfigDrop());
		Sqlite3PerformScript(sch.Config());
	}

Unless you add a primary key on two columns in an existing table it works ok.

Report message to a moderator