Subject Select Distinct command
From Emeka <megameks@yahoo.com>
Date Sun, 10 Jun 2018 08:33:50 -0400
Newsgroups dbase.getting-started

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