>>Hi everybody,
>>
>>When I'm running insert command (or replace, of some alike commands), if Source file has data, which are greater than the numerical field length in the Destination file, I have an error "Numerical overflow" and program stops its execution. My question is: is it possible to automatically clear the field, which is giving the error (the field in unknown) and process the file silently (may be note the error in error log, but don't stop)?
>>
>>What would be your suggestions about this, I think, common problem?
>>
>>Thanks in advance.
>
>Hi Nadya,
>
>If you try something like
>
>LOCAL;
>llErr
>
>create cursor murks (nField n(1))
>ON ERROR llErr=.T.
>insert into murks (nField) values (10)
>
>if llerr then
> blank fields nField
>endif
>
>
>or more sophisticated stuff with methods
>
>Agnes
Hi Agnes,
The interesting thing is, what your code doesn't fire an Error, but * gets inserted!!!
However, then I changed it to
nField = 100
append blank
gather memvar
I got an error. So, insert and replace/gather behave differently!!!!
BTW, aerror doesn't contain a field name, as I hoped, so this info is useless in this particular case...
If it's not broken, fix it until it is.
My Blog