1. Rebecca Tollfree
  2. PowerBuilder
  3. Thursday, 1 April 2021 09:33 AM UTC

Hi

I am working with retrieval arguments on a datawindow

i am using a number datatype, and have noticed that the datawindow corrupts if I put in a really big number (32bit). If I change the data type to decimal there is no problem

 

I have been trying to find the difference between these two datatypes in retrieval arguments but I cannot find the documentation

Does anyone know what the upper limit of the number datatype is in a 32 bit environment, and the range for the decimal data type in comparison?

 

Thanks :)

 

 

Accepted Answer
Chris Pollach Accepted Answer Pending Moderation
  1. Thursday, 1 April 2021 16:54 PM UTC
  2. PowerBuilder
  3. # Permalink

Hi Rebecca;

  FYI: The DWO's NUMBER data type only supports 18 digits. So Matt's suspicions were correct.

HTH

Regards ... Chris

Comment
There are no comments made yet.
Matthew Balent Accepted Answer Pending Moderation
  1. Thursday, 1 April 2021 13:35 PM UTC
  2. PowerBuilder
  3. # 1

From the Help on 'Standard Datatypes':

Decimal or Dec

Signed decimal numbers, positive or negative, with up to 28 digits. You can place the decimal point anywhere within the 28 digits -- for example, 123.456, 0.000000000000000000000001 or 12345678901234.5678901234.

 

There isn't anything I found on 'Number' but I assume it is less than 28 digits...

Comment
There are no comments made yet.
Rebecca Tollfree Accepted Answer Pending Moderation
  1. Tuesday, 6 April 2021 07:10 AM UTC
  2. PowerBuilder
  3. # 2

This is exactly the sort of info I was looking for - thanks guys! :)

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.