Whilst we're using 4.1.4 for most of our development, on e of our developers who works remotely has been using 3.23.52 for his development. In trying to migrate his database onto 4.1.4 (or 4.1.7) we appear to have hit an introduce restriction in 4.1.x. It appears that the length of the column names has a direct relationship to the number of columns allowed in a table. In the 3.23.52 database we have 1200+ columns in a table. With the same length name in 4.1.4 we can get about 200. If we restrict the name to 4 characters we can get approx 2600 columns. Is this a bug or and undocumented feature change? We're using MyIASM tables. Kevin Cowley R&D Tel: 0118 902 9099 (direct line) Email: [EMAIL PROTECTED] Web: http://www.alchemetrics.co.uk
************************************************************************************** ALCHEMETRICS LIMITED (ALCHEMETRICS) Mulberry Park, Fishponds Road, Wokingham, Berkshire, RG41 2GX Tel: +44 (0) 118 902 9000 Fax: +44 (0) 118 902 9001 This e-mail is confidential and is intended for the use of the addressee only. If you are not the intended recipient, you are hereby notified that you must not use, copy, disclose, otherwise disseminate or take any action based on this e-mail or any information herein. If you receive this transmission in error, please notify the sender immediately by reply e-mail or by using the contact details above and then delete this e-mail. Please note that e-mail may be susceptible to data corruption, interception and unauthorised amendment. Alchemetrics does not accept any liability for any such corruption, interception, amendment or the consequences thereof. **************************************************************************************