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
We really appreciate your input.
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
and a.Field7 Like 'ABC%' and b.Field1 = 'FF'
Yahoo! Messenger - Communicate instantly..."Ping"
your friends today! Download Messenger Now