How would I get the value myself?

For the first option, if I just removed the AUTHOR_ID from the InsertSQL,
will the server put it in for me?

Thanks, Stephen

> Your problem is that your generator is fired on the server, whereas you
> insert on your client. You have to tell IBX to not check for this value or
> get the value yourself before inserting (note, the first option will mean
> that the record most likely will disappear from your TIBDataset - there is
> no way for the server to tell the client what the value of AUTHOR_ID is if
> it is the primary key).