cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
232
Views
0
Helpful
0
Replies
Beginner

Limitations in Custom ValueList in CUIC 10.5(1)

I'm trying to create a custom ValueList to show below numbers in valuelist value. But if we use less than 9 digit number it is showing that 9 digit number correctly but If I enter more than 9 digit number, it is showing some irrelevant 9 digits number instead of my 10 digit number. I tried cast(decimal) as well and getting same result.

 

SELECT CAST(8886147651 as DECIMAL) as ID, CAST(8886147651 as DECIMAL) as VALUE 
UNION ALL
SELECT 90796 as ID, 90796 as VALUE 
UNION ALL
SELECT 90797 as ID, 90797 as VALUE

 Value showing as:

 

image.png

1. Is there any limitation in valuelist digit count in CUIC?

2. Why i'm not able to see the 10 digit number in valuelist but in SQL Server Management Studio with/without using cast(decimal) or conversion, i'm able to get that value?

Thanks and Regards,
Sathiya Kumar V M
CUIC Developer
Everyone's tags (3)
CreatePlease to create content
Content for Community-Ad
August's Community Spotlight Awards