Integer field format problem

ptijsma · 2004-10-21

Hello,

One of our customers uses quantities of 10000 and higher but the field in de database is of datatype integer.
No problem because this is what it should be. The only thing is that on the form i want to display it as 10.000 (with the dot for thousand seperator)
I've been searching for a while using the Format property of the textfield, using the format function but had no luck so far.

The best thing would be to have default (display)format with the thousand seperator defined on table level.

Can anyone help me out here ?

Thanks in advance

Peter Tijsma

kine · 2004-10-21

What about set Local (Regional) settings in control panel? (separator)

ptijsma · 2004-10-21

kine wrote:

What about set Local (Regional) settings in control panel? (separator)

Nope, this is already setup correctly. With Decimal fields its not a problem. Its only the Integer fields that don't work

ZackMacKracken · 2004-10-21

You have ton use the regional and language settings of you operating system to setup the format of your choice.

Regards
Zack

ptijsma · 2004-10-21

ZackMacKracken wrote:

You have ton use the regional and language settings of you operating system to setup the format of your choice.

Regards
Zack

This is all correctly setup on the system (Numbers with thousand seperator) within the Regional Settings
The problem is with the Integer Datatype formatting

PEzechiels · 2004-10-21

What you can try is to define a global (type decimal).
Put the global on the form and fill it with the integer field.
In the properties you should set decimal places 2:0
Hope this helps you

ptijsma · 2004-10-21

PEzechiels wrote:

What you can try is to define a global (type decimal).
Put the global on the form and fill it with the integer field.
In the properties you should set decimal places 2:0
Hope this helps you

Thanks, i'll try that tomorrow.!

2tje · 2004-10-21

in the property SourceExpr fill in the field, followed by: / 1000
(it will show the decimal seperator, but that might be good enough)

kine · 2004-10-22

What about <Sign><Integer Thousand> in format exression?

ptijsma · 2004-10-22

kine wrote:

What about <Sign><Integer Thousand> in format exression?

This is what i thought at first, but strangely enough, when i do that, it won't show anything anymore

ajhvdb · 2004-10-22

So none of the above solutions work?

ptijsma · 2004-10-22

ajhvdb wrote:

So none of the above solutions work?

I haven't tried the Global Decimal variable yet, but i suppose that will work

I do think thoug, that there should be a way to set it up on table level so it will show the same troughout the system.

ajhvdb · 2004-10-22

Yes, I agree

ErictP · 2004-10-22

Perhaps you can use this.

In the OnFormat trigger of the textbox create a variable from type decimal.

OnFormat=
VAR
dDecimal@1000000000 : Decimal;
BEGIN
EVALUATE(dDecimal,Text);
Text := FORMAT(dDecimal);
END;
}

RobertMo · 2004-10-24

Following should work:
Open form in designer and set Format property for TextBox that displays your integer field/global:

<Sign><Integer><1000character,.>

I have tested for both sources: an integer table field or an integer global as source.

ptijsma · 2004-10-25

RobertMo wrote:
Following should work:
Open form in designer and set Format property for TextBox that displays your integer field/global:
<Sign><Integer><1000character,.>
I have tested for both sources: an integer table field or an integer global as source.

THANK YOU! You saved my live.
This is the best solution yet.

But... I still believe that it should be possible on table level.

RobertMo · 2004-10-25

ptijsma wrote:

THANK YOU! You saved my life.

Then you owe me a beer. A big one. And not Heineken.

ptijsma · 2004-10-25

RobertMo wrote:

ptijsma wrote:

THANK YOU! You saved my life.

Then you owe me a beer. A big one. And not Heineken.

Ok.... Amstel Beer then

Integer field format problem

Comments

Categories