0 Replies Latest reply: Apr 14, 2010 2:09 PM by Brian Munz RSS

    Dynamic DELETE from QVW question

    Brian Munz

       

      Hi,

      I'm working on a VB app which, among other things, has to delete records from a QVW. If I do a regular, normal delete such as:

      DELETE FROM table WHERE ID=7

      it works fine and will delete all rows that have 7 as an ID.

      However, if I want to delete all rows that have 7 OR 8 as an ID:

      DELETE FROM table WHERE ID=7 OR ID=8

      it doesn't work. I've run the syntax within SQL itself, so I don't think that's the problem, so is this just a bug with QV?

      Right now as a workaround, I'm looping through and doing each delete individually like this:

      DELETE FROM table WHERE ID=7; DELETE FROM table WHERE ID=8

      which isn't ideal.

      Any insight would be greatly appreciated. Thanks.