Thanks for your observations. Will stick with total() for now. All the best
Terry > On 4 Jul 2015, at 17:18, Peter Haworth <[email protected]> wrote: > > I lot depends on your application and whether you might want to move to > another SQL implementation in the future. If you think you might move, I > would define a default value of zero for the columns you plan on summing > and use (sum). That still leaves the issue of integer overflow but you can > probably work out if that is likely to be an issue for your application. > > If you're 100% sure you won;t move to another SQL implementation, I'd go > with total(). _______________________________________________ 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
