Put of all three lines of your sql in one string variable with the semi-colons and execute it as one command. Works for me using the ByteFX libraries.
Larry ----- Original Message ----- From: "Victor Pendleton" <[EMAIL PROTECTED]> To: "'Mirco Santori '" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, June 03, 2004 1:25 PM Subject: RE: VB .NET & MYSQL - LOCK TABLES > You will need to reuse your database connection, do not open a new > connection with each call or the lock will not be there. > LOCK TABLE table1 READ; > SELECT * FROM table1; > UNLOCK TABLES; > > -----Original Message----- > From: Mirco Santori > To: [EMAIL PROTECTED] > Sent: 6/3/04 2:17 PM > Subject: VB .NET & MYSQL - LOCK TABLES > > Hello MySql List, > I have create connection with VB .NET & MySql, and now i must use the > LOCK TABLES statment. > I want to know how i can use this sintax .. > > i must open connection - begin the LOCK TABLES - begin the select > statment, and then UNLOCK TABLES .. > I think so that is not correctly .. > where i can see the example for this problem ? > > Excusme for my english .. i don's speak and write very well!! > > Mirco > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]