diff options
Diffstat (limited to 'core/src/Model')
| -rw-r--r-- | core/src/Model/TransactionsModel.cpp | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/core/src/Model/TransactionsModel.cpp b/core/src/Model/TransactionsModel.cpp index 3df7990..7d53f89 100644 --- a/core/src/Model/TransactionsModel.cpp +++ b/core/src/Model/TransactionsModel.cpp @@ -11,7 +11,7 @@ SalesTable::SalesTable(TransactionModel& db) // language=SQLite : GetRowCount(db.GetSQLite(), "SELECT Count(*) FROM Sales") // language=SQLite - , GetRows(db.GetSQLite(), "SELECT * FROM Sales WHERE Id >= ? AND Id < ?") + , GetRows(db.GetSQLite(), "SELECT * FROM Sales LIMIT ? OFFSET ?") // language=SQLite , GetItems(db.GetSQLite(), "SELECT * FROM SalesItems WHERE SaleId == ?") { @@ -21,7 +21,7 @@ PurchasesTable::PurchasesTable(TransactionModel& db) // language=SQLite : GetRowCount(db.GetSQLite(), "SELECT Count(*) FROM Purchases") // language=SQLite - , GetRows(db.GetSQLite(), "SELECT * FROM Purchases WHERE Id >= ? AND Id < ?") + , GetRows(db.GetSQLite(), "SELECT * FROM Purchases LIMIT ? OFFSET ?") // language=SQLite , GetItems(db.GetSQLite(), "SELECT * FROM PurchasesItems WHERE PurchaseId == ?") { |