[Gambas-user] SQL SELECT DISTINCT

[George Neusse]

Hello,

I have been playing around with Gambas for a few versions.  I think it is a
great tool.

But.....

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.
What I see in the docs only seems to want to deal with a "WHERE" caluse.
There are things that can be done in the "SELECT" that cant be done in the
"WHERE",
How do I submit a strait SQL statement and get the returned result set.
It seems this would also be needed for stored procedures.


Am I missing something here?


Thanks,

George Neusse


Keep up the GREAT work with GAMBAS!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.gambas-basic.org/pipermail/user/attachments/20060720/47f4bc09/attachment.html>