Column Name Length Limit (None Specified)
At 22 OCT 1998 10:37:52AM Paxton Scott wrote:
According to the OI native tables doc, the column names are limited to 50 characters. In AREV 3.1, this is certainly true, and the limit of 50 characters is enforced. (seems like I remember earlier versions where characters beyond 50 were allowed but ignored, but I digress)
In OI however, apparrantly only 34 characters are actually allowed. This was discovered because I build the DB in AREV, and then started building forms in OI and since I had neglected to datatype in AREV, and had to in OI, I discovered that I could not add VARCHAR to the dict record for the long names.
So, is 34 the REAL maximum length, and the DOC is in error?
Thanks,arcs@wws.net
[url=http://www.wws.net/arcs/]ARCS, Inc.
At 28 OCT 1998 02:37PM Cameron Purdy wrote:
Hi Paxton,
Yes, the Table Builder tool in OpenInsight has a limit on the column name length of 34.
Cameron Purdy
Revelation Software