Re: [patch] Class::DBI & SQL Server

[prev] [thread] [next] [Date index for 2004/10/24]

On Mon, Jun 07, 2004 at 12:59:02AM +0100, James O'Sullivan wrote:
> When inserting a row into a table that has an auto-incrementing (identity
> in SQL Server) primary key, you can't specify the key & value in the query
> (even the value is '' or undef).  If you try to force the insert by
> setting IDENTITY_INSERT ON you lose the auto-incrementing property of the
> column.
> Perhaps there's an existing (or better) way to get around this, but I have
> attached a patch containing my solution.  If there is a better way I'd be
> interested in hearing it.

This has (hopefully) been fixed by the change to the Live Object Index key stuff.

Thanks,

Tony