Hello,
Is there 40 length limit on column names? This fails with error #406:
CREATE TABLE "BC41"
(
"BC012345678901234567890123456789012345678" INTEGER
)
VERSION 1
UNENCRYPTED
INDEX PAGE SIZE 4096
BLOB BLOCK SIZE 512
MAX ROW BUFFER SIZE 32768
MAX INDEX BUFFER SIZE 65536
MAX BLOB BUFFER SIZE 32768

Felix.

Felix


Yup, Tim introduced a length restriction. Wonderful naming convention you have there - care to share it

Roy Lambert

I built a small ORM layer over EDB that auto-constructs names based on
object/property/relation. And I like fully specified names. Together it
sometimes gives > 40 names (3 out of 250+ cases).

"Roy Lambert" <roy.lambert@skynet.co.uk> wrote in message
news:87FA1D16-568A-4641-9F5B-58466ED82A48@news.elevatesoft.com...
> Felix
>
>
> Yup, Tim introduced a length restriction. Wonderful naming convention you
> have there - care to share it
>
> Roy Lambert
>

Felix,

<< Is there 40 length limit on column names? >>

Yes, it was introduced in 1.03 and higher and has been noted in the release
notes for every release and build since that time:

============================

New Identifier Length Restrictions

Due to the above changes regarding value truncation exceptions, ElevateDB
now enforces a 40-character length limitation on all identifiers used in
ElevateDB in version 1.03 and higher.  An identifier is any name given to a
configuration or database object, such as a database, table, column, index,
etc.

WARNING
Do NOT install version 1.03 if you have identifiers in your configuration or
database(s) that exceed 40 characters until you have altered them so that
they no longer exceed the 40-character limit.  Installing and using version
1.03 without doing this first will result in your configuration or database
possibly becoming unusable.

============================

--
Tim Young
Elevate Software
www.elevatesoft.com

Felix


OK so how does it come up with

BC012345678901234567890123456789012345678

<vbg>

Roy Lambert

That was a test to find the limit...

"Roy Lambert" <roy.lambert@skynet.co.uk> wrote in message
news:72B7E94F-19BB-4158-A6A3-A1A0CC6C706E@news.elevatesoft.com...
> Felix
>
>
> OK so how does it come up with
>
> BC012345678901234567890123456789012345678
>
> <vbg>
>
> Roy Lambert
>