3 Replies Latest reply on Aug 10, 2017 1:15 PM by philmodjunk

    How to set a script IF ( Found Set = 0 )

    ezeitgeist

      I am doing a Search whose search terms could be in 1 of 2 fields in a table.

       

      What is the best way to perform a find/constrain found set, and then IF that results with 0 records returned to check the 2nd field?

       

      Would this work?:

       

      Enter Find Mode [ Pause: Off]

      Set Field [Main::Field1 ; Main::gSearch ]

      Perform Find

      If [ Get ( FoundCount ) = 0 ]

      Show All Records

      Enter Find Mode [ Pause: Off]

      Set Field [Main::Field2 ; Main::gSearch ]

      Perform Find

      If [ Get ( FoundCount ) = 0 ]

      Show All Records

      Show Custom Dialogue [ "No Records Found" ]

      End If

      End If

       

      Message was edited by: Evan Zeisel Updated to better initial potential script