<html>
  <head>
    <meta content="text/html; charset=utf-8" http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    <font face="Arial">That's it, Ken.  <br>
      <br>
      If fld# eq "" then it is empty   If fld# ne "" then it has
      something in it.   <br>
      If you press F4 in the memo and empty it, the field will again be
      equal to "" (null)<br>
      <br>
      Bill<br>
      <br>
    </font><br>
    <div class="moz-cite-prefix">On 10/5/2016 12:28 AM, Ken Cole wrote:<br>
    </div>
    <blockquote
cite="mid:CAEy9hLh_+fJRPCBnoYjT=7X-7-HzvkoLt34pRo0kN9qdyu=FVQ@mail.gmail.com"
      type="cite">Bill,
      <div><br>
      </div>
      <div>Does this work based on the content of the memo or because
        there is a memo "pointer"?</div>
      <div><br>
      </div>
      <div>How do you check if the memo actually has content and is
        empty?</div>
      <div><br>
      </div>
      <div>Ken</div>
      <div><br>
        On Wednesday, 5 October 2016, Bill Randall via Filepro-list <<a
          moz-do-not-send="true"
          href="mailto:filepro-list@lists.celestial.com">filepro-list@lists.celestial.com</a>>
        wrote:<br>
        <blockquote class="gmail_quote" style="margin:0 0 0
          .8ex;border-left:1px #ccc solid;padding-left:1ex"><br>
          Just check the contents of the memo field as you would a
          regular field.<br>
          <br>
          Say field 12 is the memo field.<br>
          <br>
          IF 12 eq "":' No memo<br>
          IF 12 ne "":' There is a memo<br>
          <br>
          Bill<br>
          <br>
          On 10/4/2016 12:48 PM, daN baueR via Filepro-list wrote:<br>
          <blockquote class="gmail_quote" style="margin:0 0 0
            .8ex;border-left:1px #ccc solid;padding-left:1ex">
            This should be a simple question. I've been asked to add
            memos to an old<br>
            application. I'm testing the memo function with a test file.
            The show memo<br>
            and edit memo commands work just fine. But to make this
            actually useful I'd<br>
            like to know if a memo has been already created for any
            specific record.<br>
            Then I could place a dummy field on the screen that says
            something like<br>
            "Please See Existing Comments - Press 'S'"<br>
            I've looked at the fpmanual but that doesn't address this
            feature? Is it<br>
            missing?<br>
            I did try using<br>
            MEMO xx CO 'mytext"<br>
            as illustrated but that doesn't pass the syntax test<br>
            <br>
            *** A filePro Error Has Occurred ***<br>
            <br>
            Line Number: 15<br>
            <br>
            memo 14 co ""<br>
                  ^<br>
            Process contains a syntax error at position indicated.<br>
            <br>
            Field 14 is 16 chrs and is MEMO type. It does works with the
            show and edit<br>
            commands.<br>
            <br>
            Anyone out there actually using the MEMO function? This is a
            SCO Unix env<br>
            running filePro 5.7.04<br>
            <br>
            Thanks in advance for your assistance.<br>
            <br>
            Dan Bauer<br>
            <a moz-do-not-send="true">dan@onlinemgt.com</a><br>
            -------------- next part --------------<br>
            An HTML attachment was scrubbed...<br>
            URL: <<a moz-do-not-send="true"
href="http://mailman.celestial.com/pipermail/filepro-list/attachments/20161004/4af60f5a/attachment.html"
              target="_blank">http://mailman.celestial.com/<wbr>pipermail/filepro-list/attachm<wbr>ents/20161004/4af60f5a/attachm<wbr>ent.html</a>><br>
            ______________________________<wbr>_________________<br>
            Filepro-list mailing list<br>
            <a moz-do-not-send="true">Filepro-list@lists.celestial.<wbr>com</a><br>
            Subscribe/Unsubscribe/Subscrip<wbr>tion Changes<br>
            <a moz-do-not-send="true"
              href="http://mailman.celestial.com/mailman/listinfo/filepro-list"
              target="_blank">http://mailman.celestial.com/m<wbr>ailman/listinfo/filepro-list</a><br>
            <br>
          </blockquote>
          <br>
          <br>
          ---<br>
          This email has been checked for viruses by Avast antivirus
          software.<br>
          <a moz-do-not-send="true"
            href="https://www.avast.com/antivirus" target="_blank">https://www.avast.com/antiviru<wbr>s</a><br>
          <br>
          ______________________________<wbr>_________________<br>
          Filepro-list mailing list<br>
          <a moz-do-not-send="true">Filepro-list@lists.celestial.<wbr>com</a><br>
          Subscribe/Unsubscribe/Subscrip<wbr>tion Changes<br>
          <a moz-do-not-send="true"
            href="http://mailman.celestial.com/mailman/listinfo/filepro-list"
            target="_blank">http://mailman.celestial.com/m<wbr>ailman/listinfo/filepro-list</a><br>
        </blockquote>
      </div>
    </blockquote>
    <br>
  <br />
<table style="border-top: 1px solid #D3D4DE;">
        <tr>
        <td style="width: 55px; padding-top: 13px;"><a href="https://www.avast.com/en-us/lp-safe-emailing-2270-b?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=oa-2270-b" target="_blank"><img src="https://ipmcdn.avast.com/images/icons/icon-envelope-tick-round-orange-animated-tick-v1.gif" width="46" height="29" style="width: 46px; height: 29px;" /></a></td>
                <td style="width: 470px; padding-top: 12px; color: #41424e; font-size: 13px; font-family: Arial, Helvetica, sans-serif; line-height: 18px;">Virus-free. <a href="https://www.avast.com/en-us/lp-safe-emailing-2270-b?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=oa-2270-b" target="_blank" style="color: #4453ea;">www.avast.com</a>
                </td>
        </tr>
</table></body>
</html>