SQL Help
Bob Sneidar
bobsneidar at iotecdigital.com
Sun Jun 3 13:44:39 EDT 2018
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 at 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
More information about the use-livecode
mailing list