That will only return the maximum value, not the record itself. Bob S
> On Jun 1, 2018, at 20:01 , prothero--- via use-livecode > <use-livecode@lists.runrev.com> wrote: > > I’m thinking something like: > > Select max(“iStoreGrp”) from “valveFlowsA” where (“valveNum”=n1 AND > “meterNum”=n2) > > Then I have to sort out how to put the statement in a string that can be sent > to php. > > Does this seem reasonable? I’ll find out tomorrow. > > Best, > Bill > > William Prothero _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode