Subject | Re: [IBDI] Generators |
---|---|
Author | Daniel Achermann |
Post date | 2000-12-11T14:52:39Z |
Roger Pullen wrote:
SELECT Count(*) FROM RDB$Generators
WHERE RDB$Generator_Name = 'YourGenName'
if the result of count = 1 -> Generators exist
if to create:
CREATE GENERATOR YourGenName
SET GENERATOR YourGenName To StartingValue
Cheers
Daniel Achermann
> Is there a way of determining if a generator of a certainExistence:
> name exists in the db, the object being to create one
> if it does not with a user input starting value
SELECT Count(*) FROM RDB$Generators
WHERE RDB$Generator_Name = 'YourGenName'
if the result of count = 1 -> Generators exist
if to create:
CREATE GENERATOR YourGenName
SET GENERATOR YourGenName To StartingValue
Cheers
Daniel Achermann