Subject [IBO] Re: Generator Question - Error querying system table & info for Helen.
Author Svein Erling Tysvær
Kristy,
simple solution - you have to use a cursor, not a dsql (i.e. switch to the
Cursor tab of IB_SQL).

Set

>Hi All!
>When I try to query the system tables for the generator names I get
>an error.
>ISC ERROR MESSAGE:
>multiple rows in singleton select
>STATEMENT:
>TIB_DSQL: "frmWISQL.dsqlEdit"