I have LO 184.108.40.206 hooked up to MySQL through Java Connector version 5.1.44 (on Windows 10), and I have a macro that assigns to a variable dim’ed as a boolean the value pulled from a query’s resultset using resultset.getBoolean(#). Unfortunately, if the value returned by the query should be Null, the boolean variable is set to false, not null. Is this behavior expected?
I can think of two reasons for this behavior that would make sense to me. The .getBoolean() is not equipped to handle null values or the boolean type in LO basic is not equipped to handle a null value.