The unified diff between revisions [d24eea5a..] and [da1bae7f..] is displayed below. It can also be downloaded as a raw diff.

This diff has been restricted to the following files: 'SQLTemplates.py'

#
#
# patch "SQLTemplates.py"
#  from [819862410d7d14aea08e6d162e6d15c964556089]
#    to [0a461ad0a72d4dfa518a60f9e14413741325f344]
#
============================================================
--- SQLTemplates.py	819862410d7d14aea08e6d162e6d15c964556089
+++ SQLTemplates.py	0a461ad0a72d4dfa518a60f9e14413741325f344
@@ -13,4 +13,6 @@ chart_sql['newledger'] = "INSERT INTO CH
 chart_sql = {}

 chart_sql['newledger'] = "INSERT INTO CHART (details, debitbalance, info) VALUES (?, ?, ?)"
+chart_sql['ledgerdetails'] = "SELECT accountid, details, debitbalance,info FROM CHART WHERE accountid='%s'"
+chart_sql['ledgerlist'] = "SELECT accountid FROM CHART"