this simple code does not work

[criZp]

This buildingprereqs stuff isn't working. Does nothing. The file is ofcourse set to load, in the properties. Any thoughts?

 

[Gedemon]

logs should tell something, if I had to guess I'd say that <PrereqBuilding> may need to reference an existing building, and so you may have to use a DELETE WHERE instead of setting a "" building as prerequisite.

 

[criZp]

Alright thanks, I rarely use delete so I forgot I could even do that. It worked : )

 

[LeeS]

Yeah, table definition solves the mystery, as Gedemon surmised:

CREATE TABLE "BuildingPrereqs" (
		"Building" TEXT NOT NULL,
		"PrereqBuilding" TEXT NOT NULL,

So if you want to eliminate a Prerequisite from an existing Building you need to delete the row rather than update it with a "NULL" value.