FiveTech Software tech support forums

I have a index problem which work in rdd "ADS".
Aa SAMPLE ITEM NO."HST-2000 " SHOULD Sorting in first one , but the
result is in last one.

Same source code work in Rdd "DBFCDX" Was CORRECT .

xHarbour :0.9970
ADS version: 8.1.018



#INCLUDE "FIVEWIN.CH"
#INCLUDE "ADS.CH"

local aDBF

aDbf := {}
AADD(aDbf, { "NO" , "C",20, 0 })

//
DBCREATE(FILE_TH+TEMP , aDbf)

USE &TEMP NEW EXCL ALIAS "ITEM"

ITEM->(DBAPPEND()) ; ITEM->NO:="HST-2000 " //==> should be first
ITEM->(DBAPPEND()) ; ITEM->NO:="HST-2000-01"
ITEM->(DBAPPEND()) ; ITEM->NO:="HST-2000-02"
ITEM->(DBAPPEND()) ; ITEM->NO:="HST-2000-03"
ITEM->(DBAPPEND()) ; ITEM->NO:="HST-2000-04"

INDEX ON ITEM->NO TO (FILE_TH+TEMP)
BROWSE()

// BROWSE SCREEN
NO
===================
HST-2000-01
HST-2000-02
HST-2000-03
HST-2000-04
HST-2000 ==> SHOULD BE FIRST, WHY ?

Hi,

In some of the collations, the hyphen (-) character sorts in front of the
space character. If you are using ANSI character sets, you can use the
ansichr.exe utility to create a new collation based on your PC's locale.
There is an option "Ignore Symbols" on the dialog where you specify the
collation name. If you check that option, the resulting collation should
have the hyphen collated after the space. If you are using Advantage
Database Server, you will have to stamp the new collation into the server
with the adsstamp.exe utility. If you are using Advantage Local Server, you
specify the name of the language in the adslocal.cfg file
(ANSI_CHAR_SET=...). You should reindex your tables after doing this.

Mark Wilkins
Advantage R&D

HI Mark :

Thank you for solution .

1)After edit adslocal.cfg ===>ANSI_CHAR_SET=ASCII
2)copy ansi.chr to work directory
3)reindex

It is the sorting what I want now !!