Hi,

> > Is it possible to insert a bunch of records related to each other via
> >
> > foreign keys without worrying about the order of inserts?
> >
> >
> >
> > I've heard that with some databases it's possible to set up a
> >
> > transaction so that referential constraints are checked only at the
> >
> > end of the transaction. Is something like this possible with Firebird
> >
> > also?
> >
>
> if insertion order is big problem, you can use triggers for

integrity-relation

> on this tables and enable-disable trigger in your transaction for make

insert.

http://www.cvalde.net/document/declaRefIntegVsTrig.htm

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com