When using Open() to run a database query with ODBC, it appears that only SELECT can be used in the query string. I tried using UPDATE, and it returned debug assertion error dbcore.cpp line 3282. However, when I call CanUpdate(), it returns true.
I once read that in order to make record changes on your database, you first need to do a SELECT query, set the new values in your program and exchange the data. Is this correct? If so, it seems long-winded. Is there a way that UPDATE can be used instead?