
Bill
In theory SqLite databases can grow to be in the Giga Byte range holding millions of records.Nevland wrote:How big is the file allowed to to grow?
If you are talking about the SqLite database, the answer is no, you can export the same data as many times as you like but if you have made a copy of the database and want to explore the potential of SqliteExpert, then you can drill down to get the data that you want for example, total KWH's between two dates goes something like thisNevland wrote:Does exporting data, like a special period, delete that data from the file ?
Code: Select all
SELECT SUM(KilowattHour) FROM MeterData WHERE MeterData.[Date] >= '2014-06-16' AND MeterData.[Date] <= '2014-06-30'
or if you want the cost, try this
SELECT SUM(KilowattHour), (SUM(KilowattHour)/100 * .25) AS VALUE FROM MeterData WHERE MeterData.[Date] >= '2014-06-16' AND MeterData.[Date] <= '2014-06-30'