>>>>>>>>Maybe this code is designed to pass Memo field as parameter, not value of Memo field but its name as 'MemoField'.
>>>>>>>>If Memo is passed as Value then TYPE(lcBodyText) must raise an error.
>>>>>>>
>>>>>>>Right, didn't notice that. If he's passing a value, he should check for type(lcBodyText)='C' instead. At least that's what I'd do - pass it as value. But if the parameter did contain the memo field's name, he wouldn't be getting the "too long" error, would he?
>>>>>>
>>>>>>No, he wouldn't. Just tested and he must not receive error anyway:
>>>>>>lcStr = [teststr]
>>>>>>? TYPE(lcStr) -> U (not error)
>>>>>
>>>>>Now I'm getting curious... how did he get this error anyway? The type(lcBodyText)="M" or he wouldn't run into this at all... but then what was too long there?
>>>>
>>>>
>>>>I don't know :-)
>>>>Maybe something happened with this library and it exceed the limitation of 65K for single routine, After he commented this part and therefore recompile classlib all gone.
>>>
>>>In Serbian, it's "we can only look into beans" (i.e. try a little magic reading). I figure you must have a similar saying.
>>>
>>>I wish the originator would chime in with a few more details.
>>
>>We have exact the the same saying - "Гледам на боб" :-)
>
>Hmmm, "Gadanie na bobax" in Russian?
The same.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.