Subject Re: Select Distinct command(Resolved) From Emeka <Megameks@yahoo.com> Date Thu, 14 Jun 2018 07:23:07 -0400 Newsgroups dbase.getting-started This is resolved. Thank you Mervyn. Emeks 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. > > Mervyn.