[Gambas-user] SQL SELECT DISTINCT

[Rob Kudla]

On Thu July 20 2006 23:49, George Neusse wrote:
> I am having some trouble with the DB object.
> I want to query a table for a field.  but i want that
> "DISTINCT" elements returned.

myResult = DB.Exec("SELECT DISTINCT * from someTable WHERE ...")

I don't know why the docs say "WHERE clause".  I don't even think 
you can specify a WHERE clause without a SELECT.  I assume 
whoever did the writeup for DB.Exec copied the text from the 
DB.Find method and forgot to change it.

Rob