Subject AutoNumber
Author Muthu Annamalai

Thanks for your help.

After seeing your message, I came to know that I have to use trigger, then I found out a way in IB expert tool to easily create autonumber using generators and triggers.

Muthu Annamalai

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.

[Non-text portions of this message have been removed]