Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 6 of 6 total |
Column name length limit |
Fri, Jul 13 2007 5:56 AM | Permanent Link |
"Felix Gartsman" | 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. |
Fri, Jul 13 2007 6:25 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Felix
Yup, Tim introduced a length restriction. Wonderful naming convention you have there - care to share it Roy Lambert |
Fri, Jul 13 2007 12:40 PM | Permanent Link |
"Felix Gartsman" | 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 > |
Fri, Jul 13 2007 4:51 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Sat, Jul 14 2007 8:32 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Felix
OK so how does it come up with BC012345678901234567890123456789012345678 <vbg> Roy Lambert |
Sat, Jul 14 2007 11:04 AM | Permanent Link |
"Felix Gartsman" | 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 > |
This web page was last updated on Sunday, May 19, 2024 at 08:46 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |