E9.1 Table update but one of the fields is a part of the Primary key.

[FrankCLT]

Hi All,

First off, this is a custom table. I know I can delete the record and then do an insert, which is what I have done in the past. Is there any way of doing this with an update that I'm not aware of?

Thank you,
FrankCLT

 

[JohnDanter2]

If it's a custom table why not add an extra column and make it an index that IS unique and then have your current key as a unique constraint index

Booommb!

 

[tpw_nz]

In a C function you can update primary key fields, either using JDB_UpdateTable or using JDB_UpdateCurrent.