Type double in progress

[mariaProgress]

Hello,I would to know if there is a type "Double " in progress , because I want to add a field of type integer and size 20 in database.

 

[TomBascom]

What version of Progress are you using?

What do you mean by "size 20"???

The int64 data type is a 64 bit integer. Int64 came with 10.2.

Decimals can handle up to 50 digits (and have been available since the dawn of time...)

 

[mariaProgress]

I use the OpneEdge101B.
size 20 is the lenght of the field.

 

[rzr]

20 - is this the number of digits you want to display on the field or hold in the db?
either way, IMHO,
DEFINE VARIABLE iMyInteger AS INTEGER NO-UNDO.
should suffice....

 

[TomBascom]

A signed 32 bit integer has a maximum size of 2,147,483,647 -- only 10 digits, and only up to "2" in the most significant digit...

A signed 64 bit integer has a maximum size of 9.2 * 10^18. So even a 64 bit integer is less than 20 digits.

Thus only a decimal can be used to get 20 digits.

I am curious to know what data needs 20 digits of an integer.

 

[Rob Fitzpatrick]

The int64 data type was introduced in 10.1B.

 

[mariaProgress]

bank account number needs 20 digit and I want to save this number in db.

I'm using a type decimal to save this number but I would use type integer .

thank you for your help .

 

[Rob Fitzpatrick]

An account number isn't something you do arithmetic on. I would store it in a character field.

 

[TomBascom]

Ditto what Rob said.

 

[jdpjamesp]

An account number isn't something you do arithmetic on. I would store it in a character field.

Oh but it's so much fun if your bank account number is 1 more than Bill Gates'. Could have all sorts of fun with arithmetic