From: "peterbelow@..." <peter.below@...>

>
> Thanks, Woody. These subtle syntax differences between SQL servers are a
> major pain in the butt <g>. I'm more familiar with Oracle.
>
> Anyway, your suggestion does not resolve the problem.
>
> OidKey is a domain:
>
> CREATE DOMAIN OidKey AS CHAR(22);
>
> Forgot to include that, sorry. If I try to create the table with
>
> CREATE TABLE HL_Oids (
> OID OidKey NOT NULL CONSTRAINT PK_OIDs PRIMARY KEY
> );
>

Not sure why there is a problem. Using IBOConsole, which uses the IBO
components, I created the same domain and table without errors and
everything seems fine. I'm using FB 1.5 so maybe there are some changes in
the newer version that I'm not aware of, however, I don't think the syntax
would change that drastically.

Are you sure the DDL isn't already autocommitted inside of FlameRobin? I've
never used it so I'm not sure how it works. Maybe someone else can jump in
here with other ideas.

Woody (TMW)