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