By the way, you can always get all matching records, convert to text, then sort the lines and get the first line.
Bob S > 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 _______________________________________________ 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