||Re: Select Distinct command
Mervyn Bick <firstname.lastname@example.org>
||Sun, 10 Jun 2018 15:35:39 +0200
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
> But its telling me Database Engine Error...Table is read only. I am using MYSQL SERVER. wHAT AM i DOING WRONGLY
Try setting the query's requestLive property false.