T
Thomas Mercer-Hursh
Guest
I am writing a tool in which I wish to have a copy of the schema of a DB in ordinary tables, i.e., the schema of the application DB represented in an analysis DB. So, I am creating tables which mirror, more or less, the metaschema tables. But, I just encountered an interesting error. One of the indexes of _Field is: ADD INDEX "_Field-Name" ON "_Field" AREA "Schema Area" UNIQUE INDEX-FIELD "_Field-Name" ASCENDING ABBREVIATED INDEX-FIELD "_File-recid" ASCENDING My version of this is identical except for the change in table and field names to make then different and regular. But, when I load this .df, I get: ** Abbreviate only allowed on last Index-Field which must be character. (362) Now, it *is* character, just like in _Field. Now, myself, I would not make it an abbreviated index because I dislike them and that may be my solution, by why is this legal for _Field and not for a user table?
Continue reading...
Continue reading...