NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: kboller on December 12, 2017, 08:40:59 AM

Title: SQL Table with Readonly AutoInc field - duplicate key error
Post by: kboller on December 12, 2017, 08:40:59 AM

Hi,

     I have a MS SQL table with an unique key field that's managed by the SQL server (flagged as ReadOnly in the database definition, external section).  However it looks like Nettalk tries to update that field when I update a record and gives a duplicate key error.  What do I need to do to get Nettalk to ignore that field for any updates?

Thanks,

Kurt

Title: Re: SQL Table with Readonly AutoInc field - duplicate key error
Post by: Bruce on December 13, 2017, 01:49:04 AM

Hi Kurt,

are you talking about _updating_ a record, or _inserting_ a new record?

cheers
Bruce