Arithmetic works on one table, but not on the other?!

[Revolutionist_8]

Hello my friends!

Does perhaps someone know why this works:

UPDATE Adjacency_YieldChanges
SET YieldChange = YieldChange * 3;

but why this one does not apply to buildings:

UPDATE Constructibles
SET Cost = Cost * 3 WHERE ConstructibleClass = "BUILDING";

(same mod. The where claus doesn't matter, it's the same)

It's maybe something trivial I'm missing, but I'm baffled to be honest

I greatly appreciate any info, thank you!

 

[PoundedChicken]

Should be perfectly valid sql. Only thing I can see is that in Adjacency_YieldChanges, data type is REAL, whereas Cost is INTEGER. Maybe they've got something in how they put these sql scripts through their DAL that scans code and prevents multiply/divide based on data type being integer and potentially throwing error to prevent crash if multiplied by a decimal value (or divided by leads to non-whole number)?

 

[Revolutionist_8]

Should be perfectly valid sql. Only thing I can see is that in Adjacency_YieldChanges, data type is REAL, whereas Cost is INTEGER. Maybe they've got something in how they put these sql scripts through their DAL that scans code and prevents multiply/divide based on data type being integer and potentially throwing error to prevent crash if multiplied by a decimal value (or divided by leads to non-whole number)?

Thank you for your feedback! I suspect something like that, I think you have a good point. If I try in XML format, a validation error is thrown, but if I set to a fix value then no problem.

I'm wondering if there is anything I can do ...(other than changing the game files themselves )

EDIT: maybe it's an issue with dependencies - only the base is tagged as dependency, while almost all buildings are separated in their respective ages. I'll check it later when I have time if that's the issue actually.