> > I am not sure if you could help me with the next question.
> >
> > Since I am not able to do it at the DB level do you know if
> I Object
> > is capable of dealing with multiple DB for cross reference? Thus,
> > removing the need for me to write loads of code just for
> the purpose
> > of cross DB refs.
> >
> > Do you know, have a nice solution or suggestions to my problem?
> >
> > danieL
>
> not for constraints - refernce maybe but not constraint Alan
>

Ok,

I am designing DB's for several applications where there is a lot of shared
data, FK's, etc. Since FireBird does not support cross DB references,
constraints, triggers, etc. How do people normally deal with this problem
when writing large complex systems with multiple DB's where there exist a
need to created FK's across DB's which are required within triggers,
constraints ,etc for the purpose of insertion, deletion and updates.

How do you attack the problem of transaction handling? Etc.

danieL
____________________________
Comvision Pty. Ltd.

www.comvision.net.au