Subject Re: [IBDI] Generators
Author Daniel Achermann
Roger Pullen wrote:

> Is there a way of determining if a generator of a certain
> name exists in the db, the object being to create one
> if it does not with a user input starting value

Existence:
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