Subject |
Re: Select Distinct command(Resolved) |
From |
Emeka <Megameks@yahoo.com> |
Date |
Thu, 14 Jun 2018 07:23:12 -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.
|
|