>
> is that YOUR script or the extracted script?
> I certainly cannot make a non-delimited field named VERSION.
> What tool do you use to run the script if it's your creation script? Have
> you compared this with the extractted metadata?
> Alan

Yes, script is mine, hand-coded.

Now I extract table metadata with IBExpert and what I received

CREATE TABLE TABLEINFO (
ORDINAL D_SMALLINT,
NICKNAME D_VARCHAR3,
TBLNAME D_VARCHAR32,
SQL D_VARCHAR32,
DESCR D_VARCHAR255,
ISACCESS D_SMALLINT_D0,
LOAD D_INTEGER_D0,
"VERSION" D_INTEGER_D0,
MODIFIED D_BEGINTIMESTAMP
);

You can see that VERSION is delimited by ". But there are no delimiters in my script.

Alan, can you create test table from next DDL in your test database under FB1.5 or FB2?

create table test (version integer)


And one question:
Do you mean that my tool delimited field name implictic ? I dont believe. Its our self-coded tool. May be something happened in access component. We use UIB.

Dmitry.

PS. Sorry for my english.