• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • Error Dysplay a Numeric(16,0) PowerServer SQL ANYWHERE

Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved Error Dysplay a Numeric(16,0) PowerServer SQL ANYWHERE

  1. How-to
0
Votes
Undo
  1. Andres Slachevsky
    Andres Slachevsky
  2. PowerBuilder
  3. Wednesday, 26 December 2018 19:13 PM UTC

Hello All,

I have a PB2007R3 PowerServer 2017 Applicacion 

with SQL ANYWHERE

i have a table with a numeric(16,0) 

with for example a value of 4338280003005454

when i run it from powerbuilder it dysplay ok

when i run it from PowerServer it dysplay 4338280003005450 when i try to modify the value it shows 4,33828000300545E+15

it have no Mask no format

if in the SQL syntax i put for example convert(char(16), col_num) it dysplay ok

please help

 

 

 

C# Full fledged or restricted
ORA-12541: TNS: no listener Error
Responses (2)
mike S
mike S Accepted Answer Pending Moderation
  1. Wednesday, 26 December 2018 21:00 PM UTC
  2. PowerBuilder
  3. # 1

sounds like a max decimals issue:

in AEM go to the PB features (under application) menu item. go to decimal precision.  then select your application and change it to 18 from 15.

Comment
There are no comments made yet.
Kai Zhao @Appeon
Kai Zhao @Appeon Accepted Answer Pending Moderation
  1. Thursday, 27 December 2018 00:29 AM UTC
  2. PowerBuilder
  3. # 2

Hi Andres,

Appeon can support the decimal precision value with
precision 15 outside the Datawindow due to the limitation of the Javascript.

And Appeon can support the decimal value with precision 28 only within the
Datawindow, and you can perform retrieve, edit, update with precision 28 within
the Datawindow, please go to AEM> Application > PB Features > Decimal Precision
> [your application] to set Decimal Precision to '28-digit Decimal'.


Regards,
ZhaoKai

Comment
Andres Slachevsky
  1. Andres Slachevsky
  2. Thursday, 27 December 2018 16:31 PM UTC
Thanks changing the configuration solve the porblem
  1. Helpful
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.