NATIONAL COLLATION AND DESCEND

[Andrzej Morgiewicz]

Hi,
I've started to open all my data with polish code page PL852 automatically. And then for data indexed with DESCENDED switch or DESCEND function in key expression, even if there are no polish national letters in keys, empty strings are at the top of order not at the bottom like it was while no using national codepage. is it for purpouse or is it a mistake in descend functionality implementation ?
Andrzej Morgiewicz

[Saulius]

Hi Andrzej,

Can you show simple sample illustrating this?

Saulius

[Andrzej Morgiewicz]

> Can you show simple sample illustrating this?
>
>
>
> Saulius

Hi
I've futher test and it occured that function descend() gives results not depented of current codepag, so indexig:
INDEX ON MYFIELD TO MYINDEX DESCENDIG works ok but
INDEX ON DESCEND(MYFIELD) TO MYINDEX gives bad order. My error was that when i've changed my command from second to first i still used descend() in seek expression!
Andrzej Morgiewicz
PS But should DESSCEND() respect codepage? this behavir prevents from proper use
of complex keys lika index on descend(name)+date+time etc

[eisoftserv]

Hello,

> Andrzej Morgiewicz
>
> PS But should DESSCEND() respect codepage? this behavir prevents from proper use
>
> of complex keys lika index on descend(name)+date+time etc

The DESCEND() function is operating with the BINARY code of eachand every character of its input argment, so it's not related to human languages. Because of this when DESCEND() is used as part of an index expression, the exact same synax MUST BE used when composing the key expression for searching. This feature is present in other xBase dialects as well.

Ella

[a...@proxima.com.pl]

// CONECT DATA BASE COLLATION POLISH_CS_AS MSSQL
FUNCTION TEST
DBCReaTE( 'AAA',{{'MC','C',2,0}})
use aaa
INDEX ON MC TO AA
INDEX ON DESCEND( MC ) TO AAA
APPEND BLANK
REPL MC WITH '01'
APPEND BLANK
REPL MC WITH '02'
APPEND BLANK
REPL MC WITH '03'
APPEND BLANK
REPL MC WITH '04'
APPEND BLANK
REPL MC WITH '05'
APPEND BLANK
REPL MC WITH '06'
APPEND BLANK
REPL MC WITH '07'
APPEND BLANK
REPL MC WITH '08'
APPEND BLANK
REPL MC WITH '09'
APPEND BLANK
REPL MC WITH '10'
APPEND BLANK
REPL MC WITH '11'
APPEND BLANK
REPL MC WITH '12'
SET ORDER TO 1
BROWSE()
SET ORDER TO 2
BROWSE()
RETURN

//is wrong