Hi, I am executing a query through executequery() expression rule. To the q

sikhivahans over 12 years ago

Hi,
I am executing a query through executequery() expression rule. To the query, i am passing an number(integer) input dynamically. The input numbers are like this : 1363852714818, 1363852714900 etc. But while passing the input as parameter, the query is unable to accept this much big number. Could anyone provide a solution for this asap?
Thanks in advance.....

Discussion posts and replies are publicly visible

Parents

0 mathanap over 12 years ago

The nast numbers like as you have, can't be stored in Number(Integer). You can store tem only on Number(Decimal). In CDT too, you need to annotate 'Decimal or Double' for that sepecified column with large number. Thus by you can avoid problems while storing that large numbers in DB.

Regarding XSD annotation refer :forum.appian.com/.../Defining_a_Custom_Data_Type
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 mathanap over 12 years ago

The nast numbers like as you have, can't be stored in Number(Integer). You can store tem only on Number(Decimal). In CDT too, you need to annotate 'Decimal or Double' for that sepecified column with large number. Thus by you can avoid problems while storing that large numbers in DB.

Regarding XSD annotation refer :forum.appian.com/.../Defining_a_Custom_Data_Type
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data