AnsweredAssumed Answered

If statements not working as they should...

Question asked by SaterInc on Oct 29, 2009
Latest reply on Oct 30, 2009 by 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.

 

Outcomes