Group by
Get Outlook for Android On Sun, Jun 3, 2018 at 7:45 PM +0200, "Bob Sneidar via use-livecode" <use-livecode@lists.runrev.com> wrote: That will only return the maximum value, not the record itself. Bob S > On Jun 1, 2018, at 20:01 , prothero--- via use-livecode 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 _______________________________________________ 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
