Victor, I think I found what you're referring to: http://dev.mysql.com/doc/mysql/en/C_API_multiple_queries.html ...
"From version 4.1, MySQL supports the execution of multiple statements specified in a single query string. To use this capability with a given connection, you must specify the CLIENT_MULTI_STATEMENTS option in the flags parameter of mysql_real_connect() when opening the connection. You can also set this for an existing connection by calling mysql_set_server_option(MYSQL_OPTION_MULTI_STATEMENTS_ON)" Can anyone tell me if this functionality is implemented in the MyODBC? If so, can you tell me how you turn it on/off? Thanks again! "Victor Pendleton" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > What version of MySQL are you using? I believe multiple delimited > statements are available in 4.1.x and later. > > Jeff Burgoon wrote: > > I'm writing my first MySQL app in VB.net using myODBC. However I think this > > question applies to all languages using MySQL. From what I understand, I > > am unable to issue a batch statement of commands separated by commas to > > mySQL. I receive an error whenever I try to do so from my app. For this > > reason, I am unable to make use of SQL variables and temporary tables. I > > must instead use persistant tables. > > > > Can anyone tell me if this is in fact the case and if so, any suggestions on > > how to get over this hurdle? > > > > Thanks, > > Jeff > > > > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
