Thanks so much, I for one can think of many reasons this could come in useful.
Bob Lee ----- Original Message ----- From: "MB Software Solutions General Account" <[email protected]> To: <[email protected]> Sent: Thursday, February 26, 2009 5:09 AM Subject: Re: MySQL + ODBC + multiple commands > Grigore Dolghin wrote: >> I sent yesterday a message about this, but somehow I messed it up and >> I sent it as a reply to some other thread. >> >> Well, I needed to send a batch of sql commands to mysql through odbc >> and I was getting synthax errors. >> >> After a while I found what the problem was - it's a OPTION value in >> connection string. The OPTION clause is documented here: >> http://dev.mysql.com/doc/refman/5.0/en/connector-odbc-configuration-connection-parameters.html >> >> In ODBC 3.51.18 a new value was introduced, which allows multiple >> statements. The option is FLAG_MULTI_STATEMENTS (67108864). If it is >> used, and the batch has multiple SELECT statements in it, VFP creates >> multiple result cursors. >> >> lcString = "Select * From users; Select * From modules" >> SQLExec(nConnectionHandle, lcString, "crsTest") >> >> This creates two cursors - "crsTest" and "crsTest1". >> >> I'm writing this maybe someone will need this information. > > > Good to know...thanks. > > But what's the real benefit over retrieving them one at a time? Just > curious. Ricardo's post yesterday sparked this question. > > > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/212a575eaae64f4588fbfd8aab7fe...@ibm7p56ctu5sgm ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
