Merge Tables not working...

2003-11-13 Thread Tbird67ForSale 
Hello,

I've posted this before, but did not get a fix or find out what I am not doing 
coreectly.  

I've established several merge tables.  3 out of the 5 of my merge tables work 
fine...but when I try to access (e.g. describe or query) the other two, I get the 
following error:

mysql describe hospchar;
ERROR 1016: Can't open file: 'employee.MRG'. (errno: 143)
mysql

I am running MySQL 4.0.15-max-nt on Windows 2000 Professional.

Any ideas?

Thanks in advance.
Tony

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Merge Tables not working...

2003-11-13 Thread Matt W 
Hi Tony,

shell perror 143
Error code 143:  Unknown error
143 = Conflicting table definition between MERGE and mapped table


Matt


- Original Message -
From: [EMAIL PROTECTED]
Sent: Thursday, November 13, 2003 4:00 PM
Subject: Merge Tables not working...


 Hello,

 I've posted this before, but did not get a fix or find out what I am
not doing coreectly.

 I've established several merge tables.  3 out of the 5 of my merge
tables work fine...but when I try to access (e.g. describe or query) the
other two, I get the following error:

 mysql describe hospchar;
 ERROR 1016: Can't open file: 'employee.MRG'. (errno: 143)
 mysql

 I am running MySQL 4.0.15-max-nt on Windows 2000 Professional.

 Any ideas?

 Thanks in advance.
 Tony


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]