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

    display/search values with pretended filter

      Hi

      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",

           "Name",

           "Birthday";

          

      SQL SELECT *

      FROM "Database1".db1."Customer";