Dynamic DELETE from QVW question

Brian_Munz — Mon, 26 Jan 2026 18:19:17 GMT

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.

topic Dynamic DELETE from QVW question in QlikView