Jul 16, 2008 08:29 PM|Moonshadow|LINK
Hi Al Dass.
Thanks for your input. As I noted, I believe I have tried about all of the options presented in this thread and the code I cited above seemed to work for SELECT and UPDATE.
I think this is probably the version that comes closest to what you have advised:
The DELETE, UPDATE, and INSERT do not work.
Here are the errors:
“SQLBindParameter not used for all parameters”
INSERT: “ERROR  [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-log]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for
the right syntax to use near ''44', 'name?')' at line 1”
UPDATE (Edit): No error message but the word “name” was put into the “id” field for every row in the table (ouch!!).