It seems that EDB has around a 40 character limit on the length of index
names?

Unfortunately, some of the index names on my customers databases are really
quite long (they are machine generated based on the name of the table and
the fields being indexed).

When migrating from DBISAM4 -> EDB I get :-

ElevateDB Error #400 The index xxxxxxxxxxx already exists

It looks like this is because it's truncating the name of the index to 40
characters and then when it tries to create another index (with the same
first 40 truncated characters) it's failing.

Is this a really easy fix that could be dropped in to 2.02b8 by any chance?

Hedley

>Is this a really easy fix that could be dropped in to 2.02b8 by any chance?

Its more of a design decision. I remember another post of Tim's giving info about what you'd need to alter if you have the source code but I don't think he's going to alter it.

Roy Lambert [Team Elevate]

Hedley,

<< Is this a really easy fix that could be dropped in to 2.02b8 by any
chance?  >>

Unfortunately, no.  The 40-char identifier limit is used all over the place
in the system information tables, so changing it could break existing
applications in a very bad way.

--
Tim Young
Elevate Software
www.elevatesoft.com