At 08:56 AM 28-06-02 +0800, you wrote:

>How to create the generator? and how to create the trigger? i am really new
>to Firebird. thanks.

Firebird is not a toy. Take Bill's advice and download the
documentation. Look in the Language Reference for the sections on CREATE
GENERATOR and writing triggers to solve your immediate problem.

regards,
heLen

All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org ·
http://users.tpg.com.au/helebor/
_______________________________________________________