U++ framework: U++ SQL » Sqlite and DUAL_PRIMARY

Home » U++ Library support » U++ SQL » Sqlite and DUAL_PRIMARY_KEY

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

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

Mon, 09 May 2016 12:34

busiek
Messages: 71
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

[Message index]

		Sqlite and DUAL_PRIMARY_KEY By: borbek on Tue, 12 January 2016 12:56
		Re: Sqlite and DUAL_PRIMARY_KEY By: mirek on Mon, 25 January 2016 13:37
		Re: Sqlite and DUAL_PRIMARY_KEY By: busiek on Mon, 09 May 2016 12:34

Previous Topic:	I am trying to have two sqls one to read another to write
Next Topic:	Global SqlIds

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Tue Jun 23 04:21:25 GMT+2 2026

Total time taken to generate the page: 0.00513 seconds