||Re: Select Distinct command(Resolved)
||Thu, 14 Jun 2018 07:23:07 -0400
This is resolved. Thank you Mervyn.
Mervyn Bick Wrote:
> On 2018-06-10 2:33 PM, Emeka wrote:
> > Hello all,
> > I am trying to use the below format for selecting distinct in a table
> > this.SUPPLIERS2 = new QUERY(this)
> > with (this.SUPPLIERS2)
> > left = 60.0
> > top = 3.0
> > database = form.storeease1
> > sql = "select distinct company,fullname from SUPPLIERS"]
> > //params["maker"] = " "
> > active = true
> > endwith
> > But its telling me Database Engine Error...Table is read only. I am using MYSQL SERVER. wHAT AM i DOING WRONGLY
> > eMEKA
> Try setting the query's requestLive property false.