Page 1 of 1
How to compare memo fields?
Posted: Fri Mar 17, 2006 9:03 pm
by carlcrespo
I have a memo field named COMMENT. I need run an if statement similar to:__IIF(COMMENT=PREVIOUS(COMMENT), ^^,COMMENT)____Or how to convert a memo to a string and then use it in a Calculated field.____The only way I found to do it in R&R is to export to a text file.____Thanks in advance, Carl
=> RE: How to compare memo fields?
Posted: Mon Mar 20, 2006 8:23 am
by kfleming
The previous function will not let you test memo fields. No way around this restriction.____Kathleen__R&R Support
==> RE: How to compare memo fields?
Posted: Mon Mar 20, 2006 12:23 pm
by carlcrespo
>The previous function will not let you test memo fields. No __>way around this restriction. __>__>Kathleen __>R&R Support ____How do I compare or delete duplicate memo records? My company stores names in a memo fields. ____Can memo fields converted to strings using calculated fileds?
===> RE: How to compare memo fields?
Posted: Fri Mar 24, 2006 9:28 am
by Greve
I have also run into limitations reporting on memo fields for one of my clients. As a workaround, I created a FoxPro program to convert the memo fields to character fields and then report against the converted table with char fields. I also scheduled the program using Windows Scheduler to run at night so that the data is up-to-date as of "yesterday".____Hope this helps,____Rob