dBLib

[Peter Haworth]

On Fri, Sep 12, 2014 at 9:50 AM, Terence Heaford <t.heaford at btinternet.com>
wrote:

> put merge("select sum(amountColumn) as totalValue from amountColumn where
> amountColumn < 0 and date >= [[tStartDate]] and date <= [[tEndDate]]") into
> tSQL


Not sure if dbLib supports it but you could use the BETWEEN operator
instead of >= and <= checks on the date.

Pete
lcSQL Software <http://www.lcsql.com>
Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and
SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html>