Hi,

> Yeah removing a second index on the field helped. Thanks Martijn. I'm

still

> interested however in the standard code that people normally use for
> creating foreign keys, whether it be with CREATE TABLE or ALTER TABLE.
>
> I'm sure this is something many of you do on a regular basis and it would
> help me who is not a Firebird expert.

I always use InterBase Workbench - it generates the DDL for me :)

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."

> Thanks,
> Stephen
>
>
>
> > Hi,
> >
> > Well, if this is the only meta data changes you did, then I would say
> > that either CODING_ID is not a primary or unique constraint in the
> > CODING table. Or (which, btw, is a small bug) you have additional
> > indices on the CODING.CODING_ID field.
>
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>