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]