Hi Harri

No am NOT!! I made this only for testing the possibility of "Trigger Views".
It is not in use in a production system - it lives only in my own "syntax
example database" :-) But perhaps somebody out there knows if generators are
"transaction safe"?

Ralf Grenzing

harri007et schrieb:

> Hi Ralf,
>
> > insert into Partner (Partner_id, Name, Ort)
> > values (gen_id(Partner_id, 1), new.Name, new.Ort);
> >
> > insert into Lieferanten (Partner_id, Telefon, KontaktPerson)
> > values (gen_id(Partner_id, 0), new.Telefon, new.KontaktPerson);
>
> are You sure that the second gen_id() gives always the correct result
> in multi-user environment?
>
> Harri Rõuk
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/