>>>Most likely you've something in the memo field that looks like empty but it's not. What ASC(mymemo) returns for it?
>
>>Sorry for this late reply. Looked like there were non-visible characters at the end.
>
>the EMPTY() function will return false for a memo field when it has any characters (including spaces) in it.
Hi Sergey and Denis,
Interestingly that this function works differently for Memo and character fields.
CREATE CURSOR cTest (mField M, cField C(10))
INSERT INTO cTest VALUES (SPACE(10), SPACE(10))
?EMPTY(mField)
?EMPTY(cField)
If it's not broken, fix it until it is.
My Blog