Page 1 of 1
Length of memo field
Posted: Fri Jun 23, 2006 3:15 pm
by DCSykes
How can I test to see if a memo field contains any data? What I^m trying to do: if there is no data in the memo field, the line is blank. Otherwise, I^m to print "ATTENTION"^ followed by the memo information. I^ve tried the method I use for character fields (len(trim(fldname))=0) but it won^t work on a memo field.____R&R xBase v11, build 11.0.003.____Thanks,__Dennis
=> RE: Length of memo field
Posted: Wed Jun 28, 2006 1:13 pm
by DCSykes
Does no answer to my question mean there is no way to check memo field length with R&R?____>How can I test to see if a memo field contains any data? __>What I^m trying to do: if there is no data in the memo __>field, the line is blank. Otherwise, I^m to print __>"ATTENTION"^ followed by the memo information. I^ve tried __>the method I use for character fields (len(trim(fldname))=0) __>but it won^t work on a memo field. __>__>R&R xBase v11, build 11.0.003. __>__>Thanks, __>Dennis __
=> RE: Length of memo field
Posted: Wed Jun 28, 2006 2:30 pm
by kfleming
[updated:LAST EDITED ON Jun-28-06 AT 02:32 PM (EST)]Create a calculation that says:__IIF(memofldname,ATTENTION","")____where memofldname is the name of your memo field.__ ____Kathleen__R&R Support____Note that the smiley that prints is really a closing paren.
==> RE: Length of memo field
Posted: Thu Jun 29, 2006 2:00 pm
by DCSykes
Thanks, Kathleen. That got me onto the right track.____Dennis____>Create a calculation that says: __>IIF(memofldname,ATTENTION","") __>__>where memofldname is the name of your memo field. __>__>__>Kathleen __>R&R Support __>__>Note that the smiley that prints is really a closing paren. __