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.