How to update Yes/No column in using prepared statement?

[Andrew Tamon]

I was trying to update a column in my access that is yes/no type.
i was trying to set it as query 1 or -1 i also tried to set it as boolean true but have no effect, no error was been detected.

[Gord Thompson]

This works fine in UCanAccess 4.0.4:

String sql = "UPDATE Table1 SET yesnoField=? WHERE id=1";
PreparedStatement ps = conn.prepareStatement(sql);
ps.setBoolean(1, true);
ps.executeUpdate();

[Andrew Tamon]

thank you very much it did work.