On Wednesday 14 August 2002 02:30, Artur Anjos wrote:

> You must get the value form the generator on the SP, not in the trigger BI.
> Change your trigger that it just fires the generator creation if it is not
> defined already.

Finally I changed the trigger code so that it only creates a primary key in
case a null value is given. Then I changed the stored procedure as suggested,
increasing the generator value "manually".

Thanks! :-)

--
Jaume Andreu Sabater Malondra
jsabater@...
Registered linux user #209072

"Ubi sapientas ibi libertas"