[Gambas-user] SQL SELECT DISTINCT

Benoit Minisini gambas at ...1...
Sun Jul 23 00:10:24 CEST 2006


On Saturday 22 July 2006 22:28, Rob Kudla wrote:
> 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
>

But who did that? :-)

-- 
Benoit Minisini




More information about the User mailing list