Erik,
Thanks for reply, so, I'd better set talk off. I set it on in order to see termometer during SQL execution. Very strange bug... I spent ~2 hours trying to solve the problem. What should I do without UT? :)
Fred, Ed, thanks to all of you too.
>>>3) In my SQL I have an error:
>>> Cannot access characters beyond string (Error 62). What should I do?
>>>
>>
>>Look for a function where you reference an offset in a string; this error indicates that the number is bigger than the length of the string, or is negative.
>
>I might add also that, strangely, this error only menifests itself when SET TALK is ON. Otherwise, the function that tried to access the extra characters just returns an empty string. I call that a bug.
If it's not broken, fix it until it is.
My Blog