Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Numeric overflow error
Message
 
 
À
23/06/2023 10:28:57
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Divers
Thread ID:
01686774
Message ID:
01686776
Vues:
40
>>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”   && created in code which I omit here
>>
>>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform