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

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

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
datatype)."

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.

...to do what?


regards,
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 www.ibobjects.com