3 Replies Latest reply on Nov 16, 2012 5:39 AM by StanMillar

    Finding container fields with missing referenced data

    StanMillar

      Hi all

       

      FM11/FM12

       

      I have a container field, Document_r, that is set to store data (usually pdfs) as a reference.

       

      For various reasons, some of the referenced data have been deleted and, of course, FileMaker cannot find the referenced file. The container field then displays the text "The file cannot be found:" followed by the path to where the pdf should be.

       

      What I am trying to do is isolate these records so that I can delete them before converting the containers to the new secure storage in FM12.

       

      To isolate the records, I want to set a number field to 1 and then find the fields with 1 in them.

       

      I have tried:

       

      PatternCount ( GetAsText ( DocumentStore::Document_r ); "found"

      not IsValid ( DocumentStore::Document_r )

      IsEmpty ( DocumentStore::Document_r )

      Get (Last Error ) ≠ 0

       

      none of which was successful.

       

      GetAsText ( DocumentStore::Document_r ) simply shows:

      file:[filename].pdf

      filemac:/filepath/[filename].pdf

       

      It appears that the text "The file cannot be found:" does not exist in the field and is used only as a display object.

       

      Any suggestions?

       

      Thanks, as always.

       

      Stan