AnsweredAssumed Answered

Not equal not working in relational script

Question asked by ScottYoung on May 15, 2013
Latest reply on May 15, 2013 by 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.

Outcomes