Announcement

Collapse
No announcement yet.

[SOLVED] Select distinct is ignored.

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • [SOLVED] Select distinct is ignored.

    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.
    Albert Drent
    aducom software netherlands
    scriptcase partner, reseller, support and (turn-key) development
    www.scriptcase.eu / www.scriptcase.nl

  • #2
    Hello Mr. Drent,

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

    regards,
    Bernhard Bernsmann

    Comment


    • #3
      You can drop this one.
      Albert Drent
      aducom software netherlands
      scriptcase partner, reseller, support and (turn-key) development
      www.scriptcase.eu / www.scriptcase.nl

      Comment


      • #4
        Ok,

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

        regards,
        Bernhard Bernsmann

        Comment

        Working...
        X