SQL help

[Moriboe]

I've been trying to change the required tech for all unit (worker/GP) builds that remove jungle or marsh, using SQL. I've got other SQL working before (moving all renaissance+ techs one column right), but after many variations of this one I've had no success:

UPDATE BuildFeatures
SET PrereqTech = 'TECH_BIOLOGY'
WHERE FeatureType = 'FEATURE_JUNGLE'
AND Remove = 'true';

UPDATE BuildFeatures
SET PrereqTech = 'TECH_BIOLOGY'
WHERE FeatureType = 'FEATURE_MARSH'
AND Remove = 'true';

I put an UpdateDatabase command for it in Actions. Any ideas are welcome!

 

[MouseyPounds]

SQLite databases store booleans as integers. Try changing the second condition to "AND Remove=1"

 

[Moriboe]

Thanks! Will try when I get back