Subject Re: Synchronization Help (now: AutoNumber)
Author Aage Johansen
On Fri, 9 Jan 2004 16:04:21 +0000 (UTC), Muthu Annamalai wrote:

> ...
> I need another help instead,

You should really start a new thread

> I created Generators for Autonumbers in IB Expert for my table.
> And when I try to leave that autonumber ID coloumn blank and fill the
> rest of coloumns the server is not allowing as it is a non null pk.
> So I manually fill it up with 0, 1, 2....
> How can I fix this.

There are severeal ways ...

Try with a BeforeInsert TRIGGER, with a body like

if (ID is Null) then ID = gen_id(YOURGENERATOR, 1)

- the syntax may be slightly off, but you get the point

Aage J.