Subject Re: [ib-support] Re: another Error
Author Bernhard Doebler

thank you very much for your information.

I solved some problems with help of the manual at

You helped me very much too understand Interbase.

Best Regards

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

----- Original Message -----
From: "Lucas Franzen" <luc@...>
To: <>
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: