Subject Re: generator of generators
Author duilio_fos <irel_llc@libero.it>
Benno,

> When a company is added, give it a unique ID number (using a
generator).
> Than when adding records, als add this ID to the row. That way you
could identify the company.

the problem of getting a number to identify the company is trivial.

What I need is to provide the new company with a generator (unique to
the company) with which the company will identify (count) its records.

I can easily create the new generator I need programmatically, e.g.
by a using a TIB_DSQL.

I just thought it would be smart to have the generator created in the
After Insert trigger of the COMPANIES table.

Alas, it seems not possible.

Thank you

Duilio