Hi,

>Is the Generator an INT64 ??
>The documentation says it is an INT and when i tried to set the value
>using interbaseworkbench I found that it was only allowing upto int
>values.

A generator in a Dialect 3 database will return an INT64 value.

>Is there any setting that i have to change to make generator an int64.

>I would really like to use this idea but hesitate to do so when it is
>only int

Are you setting it via the Generator Editor or via the DDL statement
"SET GENERATOR"?

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."