[SOLVED] Select distinct is ignored.

Scriptcase 7 Bugs
#1

I have a grid with following SQL statement

SELECT DISTINCT EMPLID,
NAME_FORMAL,
LAST_NAME,
FIRST_NAME,
NAME_INITIALS,
SEX,
BIRTHDATE
FROM
SYSADM.PS_RUG_MEDEWERKERS

If I use a search then I get duplicate rows, which is not correct.

When I enter this statement in sqlbuilder it gives the expected results.

#2

Hello Mr. Drent,

When all data is loaded, without any filter/search is the distinct being ignored?

regards,
Bernhard Bernsmann

#3

You can drop this one.

#4

Ok,

Please let us know if you run into this issue again.

regards,
Bernhard Bernsmann