That will only return the maximum value, not the record itself. Bob S
> On Jun 1, 2018, at 20:01 , prothero--- via use-livecode > <[email protected]> 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 [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
