Subject | Re: generator of generators |
---|---|
Author | duilio_fos <irel_llc@libero.it> |
Post date | 2003-03-01T23:58:34Z |
Benno,
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
> When a company is added, give it a unique ID number (using agenerator).
> Than when adding records, als add this ID to the row. That way youcould 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