From: A Z (xtcsukyahoo.co.uk)
Date: Wed Feb 25 2004 - 05:51:14 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

I am running Delphi 6 Ent. along with Corelab
technology to access MySQL 4.1.14.

We run into problem of table coruption (error: 127,
145) from time to time using the following SQLs. This
is done in the transaction context. Most of the time
it works fine but it does get into problem. We have
tested it with simple insert and it seems to be
working fine.

We really appreciate your input.

{SQL}

Delete From Table1

INSERT INTO Table1 (Field1, Field2) SELECT a.Field1,
'2004-02-25' From Table2 a LEFT Join Table3 b ON
(a.Field1 = b.Field2)
where a.Field4 = '0' and a.Field5 = '0' and a.Field6
<= '2004-02-25'
and a.Field7 Like 'ABC%' and b.Field1 = 'FF'

regards

        
        
                
___________________________________________________________
Yahoo! Messenger - Communicate instantly..."Ping"
your friends today! Download Messenger Now
http://uk.messenger.yahoo.com/download/index.html

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]