![]() ![]() "UPDATE BuildingClasses SET ID = 1 WHERE ID = 103 " works just fine. I thought maybe the tables were somehow resistant to ID change, but that's not the case. That's weird! How could a Civ5 update change the behavior of an external program? Is it changing the table definition somehow? (I looked at Create statement in the Structure tab and didn't see anything strange.) In fact, the code doesn't even work in SQLite Manager. So IDs start at 100 or whathaveyou (it's a total conversion mod with tables mostly emptied out before being refilled). All the data got in, but the ID renumbering failed. UPDATE BuildingClasses SET ID = ( SELECT IDRemapper.id-1 FROM IDRemapper WHERE BuildingClasses.Type = IDRemapper.Type) ĭROP TABLE IDRemapper I browsed many different mod tables and the basic problem is the same. INSERT INTO IDRemapper (Type) SELECT Type FROM BuildingClasses CREATE TABLE IDRemapper ( id INTEGER PRIMARY KEY AUTOINCREMENT, Type TEXT )
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |