Hi,

> fb 1.5.1 ss
>
> I run following in a query to return generators in
> the database :
>
> a) This returns no generators at all
>
> select rdb$generator_name from rdb$generators
> where rdb$system_flag<>1
> order by 1
>
> b) This returns all system generators
>
> select rdb$generator_name from rdb$generators
> where rdb$system_flag=1
> order by 1
>
> c) This returns system generators and
> all defined generators
>
> select rdb$generator_name from rdb$generators
> order by 1
>
> d) Question : How to show only defined generators ?

where rdb$system_flag=0 or rdb$system_flag is null

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com