Hi,

thank you very much for your information.

I solved some problems with help of the manual at http://www-lincks.ida.liu.se/~TDDI60/2000/labs-faq-interbase.html

You helped me very much too understand Interbase.

Best Regards
Bernhard

p.S. I don't design the whole database but have to add some tables. This makes it harder for me.
I used the CASE tool http://www.casestudio.com/

----- Original Message -----
From: "Lucas Franzen" <luc@...>
To: <ib-support@yahoogroups.com>
Sent: Friday, July 27, 2001 1:00 PM
Subject: Re: [ib-support] Re: another Error



> Just some thoughts:
>
> 1. you should use INTEGERS not SMALLINTS for Primary keys
> 2. it's no good idea to have a field referencing a table where the field
> has got the same name as the table it is referencing (might be the
> solution to your problem).
> 3. you don't have to declare NO ACTION, this is default
> 4. you shouldn't default a primary key
> 5. if you don't want to mess around with INTEG_95 (and browsing the
> system tables to find out which relation this is) you can name the
> primary key like:
>