The article from Claudio is on my opinion one big recommendation to use FK
constraints ...
Ales

> -----Original Message-----
> From: Frank Ingermann [mailto:frank@...]
> Sent: Tuesday, August 27, 2002 12:18 PM
> To: ib-support@yahoogroups.com
> Subject: Re: [ib-support] Re: Helen: Low Selectivity Problem
>
>
> Hi Ryan,
>
> Scronkey wrote:
> > --- In ib-support@y..., "Alan McDonald" <alan@m...> wrote:
> >
> >>I might jump in here...
> >>I do not use foreign keys at all in my databases!
> >>ooooh I hear frowns and tisk tisks here....
> >>but nonetheless, my triggers do all the work for me. They also
> >>provide a far more comfortable environment to develop in.
> >>
> >>Alan
> >>
> >
> >
> > Could you possibly point me to some info regarding triggers and RI?
> > I'm quite new to FB / triggers / sp's
> > I will research CREATE EXCEPTION like Helen suggested.
> >
> > Rgds,
> > -Ryan
>
> this might be something for you: Claudio V.'s article on
> "Declarative referential integrity v/s triggers"
> http://www.cvalde.com/document/declaRefIntegVsTrig.htm
>
> it explains some important issues to keep in mind when doing
> RI "by hand". what
> it doesn't have is example triggers - in case you get stuck,
> just keep asking :-)
>
> (i'm doing RI by hand because a) nothing ever gets deleted in
> my gdb and b) all
> relations/joins go via surrogate keys, so what's left of RI
> is so little that it
> is easier done with triggers *in my case*...)
>
> regards & hth,
> fingerman
> --
> --------------------------------------------------------------
> -----------
> when parsers parse, and compilers compile, then why don't
> objects object?
>
> fingerbirdy - fingerman's door to Firebird
> http://www.fingerbird.de
>
>
> ------------------------ Yahoo! Groups Sponsor
> ---------------------~-->
> 4 DVDs Free +s&p Join Now
> http://us.click.yahoo.com/pt6YBB/NXiEAA/mG3HAA/67folB/TM
> --------------------------------------------------------------
> -------~->
>
> 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/