SQLite Issue and workaround

General Information about POS Pizza 8
Post Reply
User avatar
Scott
Site Admin
Site Admin
Posts: 2557
Joined: Wed Apr 16, 2003 5:35 pm
Location: Western PA

SQLite Issue and workaround

Post by Scott »

While working on some of the new features in POS Pizza v9, we uncovered an issue with SQLite where it returns erroneous data in some rare instances where a BETWEEN clause is used. There were a couple of reports in POSPizza v8 where these were used, so we replaced them with equivalent statements which yield the same result without the use of the BETWEEN clause. To download the updated version of the POSReports, click on this link. https://summitcn.com/downloads/POSReports_v8.71.01.zip The likelihood that you were seeing issues with this is slim, but updating your reports file couldn't hurt.

For [CS] versions, unzip this file into the C:\POSPizza6\CS folder on each station.
For the [SA] version, unzip this file into the C:\POSPizza6\SA folder.
For the [LT] version, unzip this file into the C:\POSPizza6\LT folder.

Scott
Post Reply