OK. So its a real reproducible bug. Who's going to submit it to MS? I've never attempted doing a replace in a UDF that is called from a replace command. I'd redesign this code.
>Thanks, Sergey. Notice, that gather memvar in UDF has the same effect, as replace in UDF, but insert from memvar works in UDF.
>
>So, what should we do with this info? :)
>
>>Hi Nadya,
>>
>>Hee's a code that reproduces your problem with min of code
CLOSE DATA
>>create cursor curT1 (RecNum I)
>>create table OutPut (Num1 N(2), Date1 D)
>>append blank in OutPut
>>replace Num1 with 100, Date1 with Repl1()
>>RETURN
>>function Repl1
>>replace RecNum with 1 in curT1
>>RETURN Date()
>>
Comment out Replace command in the UDF and you'll get "Numeric Overflow" error.
>>
>>>>>Yes, and apparently a goodly number of the reported ones too! Since we can't
>>>>>KNOW, given the present circumstances, my recommendation is don't waste the >effort.
>>>>
>>>>Hey, cool, since I don't work for MS anymore, I don't have to let this post go without comment.
>>>>
>>>>But it's not worth it, so I won't bother.
>>>
>>>Garrett,
>>>
>>>Could you please comment about the nature of the problem? Can you replicate it, because it's weird. My tests didn't work and Mike's did...