I found in other discusion thread that currently it's not possible... What i did was to "split" the code in multiple SQL Statements, i put them in an array and executeted one by one... this solved the problem, but i'm concerned about performance issues.
FB > I think you can't. > Even MySQLcc runs one after one. > In fact it takes one statement and runs it. After that, it runs the > following statement. The thing is not sent on the server at once. > I might be wrong!!!!! (not an expert) > > Thanks > Emery > ----- Original Message ----- > From: <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, September 26, 2003 05:52 > Subject: Can't execute code in VB 6.0 > > > > I'm trying to execute a code with multiple SQL statement over VB 6.0. The > > code includes the creation of temporary tables, multiple inserts and one > > final select... > > It looks like i can only excecut one single SQL statement... does any one > > know how to fix that? > > > > I can run the code with out problems using MySQL Control Center. > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql? [EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
