3 Replies Latest reply on Oct 30, 2009 6:33 AM by SaterInc

    If statements not working as they should...

    SaterInc

      Title

      If statements not working as they should...

      Post

      I'm working on a database for the company I work for, now i'm to the fun part of writing up various reports that suit our needs.  I'm having a problem with my If statement spotting if the qty on my orders are not equal to 0.  It seems to omit only every other record regardless of the qty in stock.  If i manual change the qty to 0 then it does spot it, but not otherwise. 

       

      here is the two scripts i am running for said sort...

      Script 1 (START BUTTON FOR CLOSED ORDER SORT)

      goto record (first)

      perform_script("SORT OPEN ORDERS")

      Goto Layout("report")

      Enter Browse Mode

      Pause/Resume Script

      Show All Records

       

      Second Script(sort open orders)

      Goto Layout(inventory)

      Goto Record(first)

      Loop

          If (Inventory::DYN_QTY notequal 0)

           Omit Record

          end if

       goto record(next) exit after last

      end loop

      goto layout (original )

       

      IF anyone can think of why this is not performing as it should, any help is appreciated.