Help

[zorpavns]

Help
How to index positive and negative numbers. So put them in a rising order.

When the number is converted to a string, it disappears like this:

-10000.00
20000.00
-5000.00
5000.00
Does anyone have an idea of ​​how to fit properly.

Thanks in advance

[Marin]

Hi zorpavns,

Try using:
INDEX ON VAL(char_field) to File_NTX.

Regards,
Marin

[zorpavns]

What to do when a combined index is composed of letters and numbers

[Marin]

What to do when a combined index is composed of letters and numbers

Please kindly give an example of your index key resulting data. Up to now we were talking about numbers only, i guess...

[zorpavns]

Example index

vrs=Ch2
Sal=Numeric 19,2

vrs+str(sal,19,2)

[trmpluym]

Zorpavns,

There is a simple solution for this problem. You can simply add a large number to compensate the largest possible negative number.

For example when the field has got 4 positions add 99999 (five times 9).

STR(NumField+99999)

The index would be always positive and the sort order is correct.

Theo

[ROBROS]

Hi Zorpavns,

"Mixed" index: persnr is a "C", character field, date is "D", date field.

My index: index on persnr+dtos(date) to indexfile.

Regards
Robert

[edk]

Try instead of str () to use a strzero ()

[BeGeS]

I would create this function:

Code: Select all

FUNCTION NEGATEX(NUMERO)
LOCAL RESUL
 IF NUMERO<0
    RESUL:= "-" + STR(ABS(NUMERO),18,2)
 ELSE
    RESUL:= STR(NUMERO,19,2)
 ENDIF
RETURN RESUL

Your index:

vrs+NEGATEX(sal)

[zorpavns]

Greeting.
You should need help

How to connect to Microsoft sql server and retrieve data
Thanks a lot