3 Replies Latest reply: Oct 18, 2012 1:09 PM by mayilvahanan ramasamy RSS

    Loading Data From The DB using Scripts

    Anuradha Abeysuriya

      In My scrip i have,

       

      AUTONUMBER(XXX & '-' & YYY) AS YYY,

       

       

      in my DB YYY has values (A,B,C,D,E)

       

      then i want to remove C and D form the data when i'm loading Data.

       

      Then i use below SQL,

       

      In MY where Clause

       

      YYY NOT IN ('C','D')

       

      but when i load data i can see all the values.

       

      What's the wrong with my scrip

       

      Thanks