Display-Format in a Browse

[Storzum]

Hi.

I want to fill a dynamic browse with the data from a temp-table.
I define the temptable:

/* Temp-table for group */
DEFINE TEMP-TABLE tt-tmpmahn NO-UNDO
FIELD kontonr LIKE table.kontonr
FIELD uname LIKE table.uname.

I create the temp-table:
/* create temp-table */
FOR EACH table BREAK BY fc-tmpmahn.kontonr BY fc-tmpmahn.uname:

IF FIRST-OF(table.kontonr) THEN DO:
CREATE tt-tmpmahn.
tt-tmpmahn.konto = table.kontonr.
tt-tmpmahn.uname = table.uname.
END.

END.

But in the browse, where I want to display the temp-table,
I get an error:
2700000 cannot displayed in format ->>,>>9.99

When I fill the browse with the table, the field kontonr
was displayed correctly.

Where does progress get the invalid format and where and how
can I change it?

Thanks.
Storzum

 

[bendaluz2]

->>,>>9.99 is the default format mask for a decimal field and is how table.kontonr
has been defined in the database. This is why tt-tmpmahn.kontonr has this format mask when you define it LIKE table.kontonr. You need to override the format mask with one that can cope with the data in your table

DEFINE TEMP-TABLE tt-tmpmahn NO-UNDO
FIELD kontonr LIKE table.kontonr FORMAT ">,>>>,>>9.99"
FIELD uname LIKE table.uname.

This definition will allow the browse to display the value 2700000 that you mentioned. If there are larger values, you'll need to increase this further

 

[Storzum]

FIELD kontonr AS INT FORMAT "9999999"

also works.

 

[bendaluz2]

True, but as your field is a decimal, I am presuming that you have some records that have a decimal portion