Hi,

Just a note...

> > Thing about that table that requires, forced by integers, that records
> > are entered by the user in a certain order. It works ok. But if you
> > have to automatically "pump up" (already correct and fine) data in
> > that table with "insert from...", you can't do it in the correct
> > order, so trigger protection fires.
>
> I don't think that is something that would come up in for
> many of us. Since there is NO natural order in a relational
> database, the order is always controlled by an index.

Order is always controlled by an ORDER BY - I assume you
wanted to say that...


With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com