3 Replies Latest reply on Dec 28, 2006 8:23 AM by proxim00

    help with a valuelist

    proxim00
      Hi,

      I posted yesterday asking a question about deleting some stuff from my DB and somone suggested I use a value list, so basicaly Im getting all the stock number and putting them in a value list, then running a delete statement like this

      where NOT IN('#Valuelist(query)#')

      Now my problem is it goes through inserts all my records then when I goto do the deletion it just deletes everything in the DB ? what could cause this? I have tried it both way with and without the single quotes but its the same results. The stock number look like this P434-133 so I don't know if thats messing it up or not as well. Anyhow I would really appreciate some help

      Thanks