SQL Help

[Bob Sneidar]

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 at 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 at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode