Subject Re: Select Distinct command
From Mervyn Bick <invalid@invalid.invalid>
Date Sun, 10 Jun 2018 15:35:39 +0200
Newsgroups dbase.getting-started

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.