Re: VB .NET & MYSQL - LOCK TABLES

2004-06-03 Thread Larry Lowry
t;[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;

RE: VB .NET & MYSQL - LOCK TABLES

2004-06-03 Thread Victor Pendleton
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 & MYS