Hi All!

When I try to query the system tables for the generator names I get
an error.

> To get the list of all the generator names:
>
> SELECT RDB$GENERATOR_NAME FROM RDB$GENERATORS
>

I get this error...

ISC ERROR CODE:335544652

ISC ERROR MESSAGE:
multiple rows in singleton select

STATEMENT:
TIB_DSQL: "frmWISQL.dsqlEdit"

> >I am saving the value of the generator into a field in my setup
> >record and I set that field up as a numeric because the data
> >definition guide says the column that holds the generated value

must

> >be defined as numeric or decimal.
>
> Where does it say that? I'd be interested to know the reference,

since it is incorrect.

Helen, you asked me where I read this...
I read this information on page 197 of the data definition guide
where it says Important on the left side of the page. Please let me
know if I misunderstood what it said.

Please let me know if there is something else I can try.

Thanks,
Kristy