-
I have set up a "DELETE * from xyz WHERE etc." but am not sure how to execute this in VB6 - I have tried database.execute and Refresh but niether of them seem to work
Any ideas? I haven't used a delete type sql before and I'm getting something wrong. The format of the Sql is OK as it works in Access. Thanks
-
I don't know if this is part of the trouble but FROM needs to be all in caps. Can you post part of your code that deals with this to give me a better idea?
Lloyd
-
"From" doesn't need to be in caps and, in fact, is an optional word.
Try removing the "*", it's not used in a delete.