3 Replies Latest reply on May 15, 2013 7:13 AM by ScottYoung

    Not equal not working in relational script

    ScottYoung

      Title

      Not equal not working in relational script

      Post

           The following script seems to work fine:

           If [IsEmpty ( DB-B::Field#1 )]
             Show Custom Dialog ["Can't find Record"; "There does not seem to be such a Record"]
           Else
             Go to Related Record [From table: "DB-A"; External; Using layout: <Current Layout>]
             Perform Script ["Go to data input" from file: "DB-A"]
             Select Window [Name: "DB-A"]
           End If

           However, this script won't do the comparison:

           If [ DB-B::Field#1 ≠ DB-A::Field#1 ]
             Show Custom Dialog ["Can't find Record"; "There does not seem to be such a Record"]
           Else
             Go to Related Record [From table: "DB-A"; External; Using layout: <Current Layout>]
             Perform Script ["Go to data input" from file: "DB-A"]
             Select Window [Name: "DB-A"]
           End If

            

           Any suggestions?
           Thank you.