Skip to Content

Wrong sort order advantage database 12

There is a strange bug in Advantage Database Server 12.

When there is the special Character "-" in a string of a data field with an Index,
Advantage Database Server do not find the correct records. The sort order of the index "UPPER(ARTICELNO)" is wrong:

Example:
aaa-bab
aaa-bbc
aaa-bcb
aaa
abc
abd

What can I do?

Jürgen Knauf

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Aug 24, 2017 at 03:37 PM

    previous ADS installations shipped a utility ansichr.exe to create your own collation sequences. It had a checkbox to 'ignore symbols' that did exact that trick.

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 25, 2017 at 11:51 AM

    Hi Joachim,

    I use as standard installation with ansi und oem collation german.

    With VO I can not find the correct record.

    Search:
    cSuche = "aaaa"
    lFound := oglServer:Seek(Upper(cSuche))

    result:
    lFound => true
    found record => aaa-bab

    It only works with oglServer:Seek(PadR(Upper(cSuche),30)).

    Add comment
    10|10000 characters needed characters exceeded

    • Isn't this just this "soft seek" vs. "hard seek" thing (on failure, a "soft seek" finds the next record with a higher key)?

      This is why we never use seek, but filter or ranges.