It seems there are some instances where MAX() does not return a value. I will send such an offending DB direct, but the sqlite3.exe results as follows:
F:\[BACKUP]>sqlite3.exe IPDB_ImptData.idb SQLite version 3.9.2 2015-11-02 18:31:45 Enter ".help" for usage hints. sqlite> SELECT max(UnitCost) FROM BOMData; sqlite> SELECT min(UnitCost) FROM BOMData; 0.0 sqlite> SELECT avg(UnitCost) FROM BOMData; 153.665947345878 sqlite> PRAGMA integrity_check(100); ok sqlite> SELECT max(UnitCost) FROM BOMData; sqlite> Note that all aggregates obtained for UnitCost on that table work, except max(). On other similar tables it works too, but on 2 specific ones I've found it not to be working. All other table checks seem to be in order. I've tested this only as far back as 3.8.11, but there it also did not work. Thanks, Ryan
