NetTalk Central

Author Topic: SQL Table with Readonly AutoInc field - duplicate key error  (Read 4048 times)

kboller

  • Newbie
  • *
  • Posts: 24
    • View Profile
    • Email
SQL Table with Readonly AutoInc field - duplicate key error
« 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

Bruce

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 11250
    • View Profile
Re: SQL Table with Readonly AutoInc field - duplicate key error
« Reply #1 on: December 13, 2017, 01:49:04 AM »
Hi Kurt,

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

cheers
Bruce