ODBC Plugin and DISTINCT

[jfxwave]

I need to fill in a combo box with just one of each name but i can't seem to get it to work. Does ODBC handle DISTINCT?


result = ODBC.OpenQuery("SELECT DISTINCT qdbname FROM test");

Thanks
Jean

[Ulrich]

ODBC just is a method for passing commands to your SQL database server. It all depends if the database you are using allows the syntax. In other words, the same SQL query may work on one database server, but not on another, because that other database doesn't feature a certain keyword you are trying to use, or needs a different syntax for it.

Ulrich