• Same code return different results

    When calling a Subprog from a button action on a Window, it executes a number of data validations, one of these validations does select in in SQL. When I execute the query in SQL, it returns the correct results. For example: When testing the same…
  • 4gl filtering tables and pop-up for incorrect prices

    Hello, I am trying to set up a SPE for the client to have an info box message pop-up if the invoice price (being NETPRI from PINVOICED table) is different than the price listed on the price list (PRI from PPRICLIST table). The problem with these 2 tables…
  • How to make a Filter returning the 'max' value from a list?

    I would like to make a filter returning the record with me max value, is there a way to do that? In SQL I use this: select MAX(NUM_0) from PINVOICE Just a example, how I can do that in X3?