I have been chasing this problem. Does not always repeat. But in the case of one customer every once in a while.
I have the following code logged (simplified)
cError = “Numeric overflow”
STRTOFILE( TTOC(DATETIME()) + " FunctionName() Error: " + cError + " Value V_CURSOR.PRINT_ORD: " +
IIF(TYPE("V_ CURSOR.PRINT_ORD")="N",ALLTRIM(STR(V_ CURSOR.PRINT_ORD)),"N/A") + CHR(13) + CHR(10), "Error.log", 1 )
The strange thing is that when a user updates several records, the value of .PRINT_ORD is recorded in log as:
4100
4101
4102
…
on so on.
until 4117
The value in .PRINT_ORD should not even be more than 100. The field itself, PRINT_ORD is Integer. So, even if the value was 4100, 4101, and so on, it should not be firing the Numeric Overflow error.
Could anyone suggest a possible problem/solution?
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham