On Fri, Sep 12, 2014 at 9:50 AM, Terence Heaford <[email protected]>
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>
_______________________________________________
use-livecode mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
