Subject Re: [IBO] RE: Generator Question - Error querying system table & info for Helen.
Author Helen Borrie (TeamIBO)
At 02:22 PM 05-02-02 +0000, you wrote:
>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:
>I get this error...
>ISC ERROR CODE:335544652
>multiple rows in singleton select
>TIB_DSQL: "frmWISQL.dsqlEdit"

Use the Cursor tab. The DSQL tab is for DML statements.

>> >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
>> >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.

This is what it says:
"Generators return a 64-bit value. You should define the column that
holds the generated value as an ISC_INT64 variable (DECIMAL or NUMERIC

Rough documentation. It must be NUMERIC(18,0) - a numeric to be sure, but one with zero scale! (These manuals never were finished!)

>Please let me know if there is something else I can try. do what?

Helen Borrie (TeamIBO Support)

** Please don't email your support questions privately **
Ask on the list and everyone benefits
Don't forget the IB Objects online FAQ - link from any page at