Numeric value out of range" exception in fetch_nd() of VIP 7.4 application
Posted: 20 Mar 2015 19:05
We have the same application written in 5.2 & 7.4 on the same SQL DB.
There is a column defined as numeric (12,0). When retrieving the data (has value greater than max of integer, for example, 5000000370) from two applications on 5.2 & 7.4, 5.3 application works w/o any error. But 7.3 application throws "Numeric value out of range" exception.
I understand the reason why it throws the exception since the value (5000000370) is greater than max of integer. The workaround is to define as varchar.
What I do not understand is that why it was working fine in 5.2 application.
I am using fetch_nd() in 7.4 application and sql_FetchNext(Stmt) in 5.2 application
I will appreciate your help in advance
There is a column defined as numeric (12,0). When retrieving the data (has value greater than max of integer, for example, 5000000370) from two applications on 5.2 & 7.4, 5.3 application works w/o any error. But 7.3 application throws "Numeric value out of range" exception.
I understand the reason why it throws the exception since the value (5000000370) is greater than max of integer. The workaround is to define as varchar.
What I do not understand is that why it was working fine in 5.2 application.
I am using fetch_nd() in 7.4 application and sql_FetchNext(Stmt) in 5.2 application
I will appreciate your help in advance