MEMO field use

Bill Randall wrandall at fptech.com
Wed Oct 5 03:43:49 PDT 2016


That's it, Ken.

If fld# eq "" then it is empty   If fld# ne "" then it has something in it.
If you press F4 in the memo and empty it, the field will again be equal to "" (null)

Bill


On 10/5/2016 12:28 AM, Ken Cole wrote:
> Bill,
>
> Does this work based on the content of the memo or because there is a memo "pointer"?
>
> How do you check if the memo actually has content and is empty?
>
> Ken
>
> On Wednesday, 5 October 2016, Bill Randall via Filepro-list <filepro-list at lists.celestial.com <mailto:filepro-list at lists.celestial.com>> wrote:
>
>
>     Just check the contents of the memo field as you would a regular field.
>
>     Say field 12 is the memo field.
>
>     IF 12 eq "":' No memo
>     IF 12 ne "":' There is a memo
>
>     Bill
>
>     On 10/4/2016 12:48 PM, daN baueR via Filepro-list wrote:
>
>         This should be a simple question. I've been asked to add memos to an old
>         application. I'm testing the memo function with a test file. The show memo
>         and edit memo commands work just fine. But to make this actually useful I'd
>         like to know if a memo has been already created for any specific record.
>         Then I could place a dummy field on the screen that says something like
>         "Please See Existing Comments - Press 'S'"
>         I've looked at the fpmanual but that doesn't address this feature? Is it
>         missing?
>         I did try using
>         MEMO xx CO 'mytext"
>         as illustrated but that doesn't pass the syntax test
>
>         *** A filePro Error Has Occurred ***
>
>         Line Number: 15
>
>         memo 14 co ""
>               ^
>         Process contains a syntax error at position indicated.
>
>         Field 14 is 16 chrs and is MEMO type. It does works with the show and edit
>         commands.
>
>         Anyone out there actually using the MEMO function? This is a SCO Unix env
>         running filePro 5.7.04
>
>         Thanks in advance for your assistance.
>
>         Dan Bauer
>         dan at onlinemgt.com
>         -------------- next part --------------
>         An HTML attachment was scrubbed...
>         URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20161004/4af60f5a/attachment.html <http://mailman.celestial.com/pipermail/filepro-list/attachments/20161004/4af60f5a/attachment.html>>
>         _______________________________________________
>         Filepro-list mailing list
>         Filepro-list at lists.celestial.com
>         Subscribe/Unsubscribe/Subscription Changes
>         http://mailman.celestial.com/mailman/listinfo/filepro-list <http://mailman.celestial.com/mailman/listinfo/filepro-list>
>
>
>
>     ---
>     This email has been checked for viruses by Avast antivirus software.
>     https://www.avast.com/antivirus <https://www.avast.com/antivirus>
>
>     _______________________________________________
>     Filepro-list mailing list
>     Filepro-list at lists.celestial.com
>     Subscribe/Unsubscribe/Subscription Changes
>     http://mailman.celestial.com/mailman/listinfo/filepro-list <http://mailman.celestial.com/mailman/listinfo/filepro-list>
>



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20161005/8a641b52/attachment.html>


More information about the Filepro-list mailing list