>>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?
>
>Are you sure that the error was caused by writing a value into this alias?
I put a line:
cPoint = "Point where the error occurred. The value of .PRINT_ORD is " + str( V_CURSOR.PRINT_ORD)
right before the REPLACE command.
Then the code goes to the CATCH to oError.
So, I presume that the error is caused by the REPLACE.
I can't think where else the error would be caused.
"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