Hi,
I was wondering if MySQL allows the ability to perform a SQL Prepare on sql
statements prior to performing an execute.
I'm using ADO on Windows and with a CommandPtr object, you can set a
property called "Prepared", that will attempt to prepare sql statements and
will keep them prepared for future use so that executes run quicker. I am
also using MyODBC for the connection to my DB Server.
I have tried to use preparing of SQL statements, but am receiving this
error:
1006 Query SELECT INVALID SELECT STATEMENT TO FORCE ODBC DRIVER TO
UNPREPARED STATE
It's not an invalid Select statement as these statements have worked for
months. So I'm wondering if it's MySQL, or perhaps MyODBC that does not
support preparing the sql statements. Previously, I have worked with other
databases using these ADO commands and this has not been a problem.
Thanks,
Sam
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
