At 06:29 PM 31-01-02 +0000, you wrote:

>I created this generator using the DSQL through the connection as
>follows
>
>create generator RCRECEIPTNO_GEN (this is just like the example in
>the data definition guide)
>
>I have tried different case such as RCReceiptNo_GEN or
>rcreceiptno_gen and any other cominbination I can think of. When I
>look at the list of generators it shows as all caps.
>
>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.

A column that is to hold the generated value should be defined as either INTEGER or (Dialect 3 only) NUMERIC(18,0), which is a 64-bit integer type.

>How do you query the system tables? Or where can I look for
>directions on how to query the system tables?

In the Language Reference manual (LangRef.pdf), in the chapter entitled "System Tables and Views".

To get the list of all the generator names:

SELECT RDB$GENERATOR_NAME FROM RDB$GENERATORS

>As always thanks for the great support.
>
>Kristy
>
>
>___________________________________________________________________________
>IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
>___________________________________________________________________________
>http://www.ibobjects.com - your IBO community resource for Tech Info papers,
>keyword-searchable FAQ, community code contributions and more !
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org
_______________________________________________________