I need to store a number in CDT field but it is giving 2147483647. Can you pleas

rishub356 over 9 years ago

I need to store a number in CDT field but it is giving 2147483647. Can you please guide me how can I store the value correctly?

Discussion posts and replies are publicly visible

0 rishub356 over 9 years ago

The initial value is in text.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 rishub356 over 9 years ago

So I was using tointeger over it.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Eduardo Fuentes
Appian Employee
over 9 years ago

Maybe your number is too big to fit in an integer, make it a decimal.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 rishub356 over 9 years ago

Thanks Eduardo but in DB it is numeric(15,0) type & I can't change the table type so will it be okay to change it to Decimal?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Eduardo Fuentes
Appian Employee
over 9 years ago

What DB is it?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 rishub356 over 9 years ago

SQL Server
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 rishub356 over 9 years ago

I tried it as Decimal & it did work. Thank you Eduardo.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Eduardo Fuentes
Appian Employee
over 9 years ago

Yes, numeric is pretty much a decimal in SQL, so it's fine to use decimal in the XSD.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 rishub356 over 9 years ago

Thanks Eduardo for the help.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 moritzw over 9 years ago

what is the largest number that can be stored in a decimal variable?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel