3 Replies Latest reply: Jun 18, 2014 3:43 AM by Tresesco B RSS

    display/search values with pretended filter


      my first question is about the simply search funktion.

      While I have connected to my database, I have many IDs:

      How can I search like: ID500***<X<ID600***

      X is my search filter, so I want to show up all IDs from ID500*** to ID600*** - for selecting them


      My second question is about to use the filter in the Script:

      I work mostly with the database, so i can only read.

      How can I use the filter in the Script  for selecting pretended values ?


      CONNECT TO Database1;


      load "ID",




      SQL SELECT *

      FROM "Database1".db1."Customer";