List:MySQL ODBC« Previous MessageNext Message »
From:Peter Harvey Date:February 12 2002 2:33am
Subject:Re: Multiple-statements
View as plain text  
Well a better example would have been consecutive DDL statements such as 
'CREATE TABLE'.

New information since I started this thread forces us to seperate the 
statements before sending them to the driver anyway because such a 
script can be too long for the driver/ODBC to handle.

Peter



Gustavo Valdes wrote:

> Why do you need them to be executed at once?
> What will you do with this information, i'm not sure if mysql recordset 
> objects can handle multiple recorsets.
> 
> 
>> From: Peter Harvey <pharvey@stripped>
>> To: myodbc <myodbc@stripped>
>> Subject: Multiple-statements
>> Date: Mon, 11 Feb 2002 16:38:20 -0800
>>
>> I just noticed that the new driver does not seem to support multiple
>> statement requests. In other words I can not SQLPrepare/SQLExecute the
>> following...
>>
>> "select cola from tablea; select cola from tableb;"
>>
>> If this is to remain then I will be forced to parse the statements and
>> submit them in a loop of some sort... I am hoping that I will not have
>> to get into that. Other drivers seem to be ok with multiple statement
>> requests but not myodbc?
>>
>> Peter
>>
>>
>> ---------------------------------------------------------------------
>> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
>> posting. To request this thread, e-mail myodbc-thread4881@stripped
>>
>> To unsubscribe, send a message to the address shown in the
>> List-Unsubscribe header of this message. If you cannot see it,
>> e-mail myodbc-unsubscribe@stripped instead.
>>
> 
> 
> 
> 
> "Life is partly what we make it, and partly what it is made by the 
> friends whom we choose."  - Chinese Proverb
> 
> 
> _________________________________________________________________
> Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.
> 
> 
> 


Thread
Multiple-statementsPeter Harvey12 Feb
Re: Multiple-statementsGustavo Valdes12 Feb
  • Re: Multiple-statementsPeter Harvey12 Feb
  • RES: Multiple-statementsMCplus12 Feb
    • RE: Multiple-statementsVenu13 Feb