Identity Insert

Nextworld Platform
1

Is it possible to insert a record into a table/subtable(main) using its original nwId? Similar like a SQL Identity Insert?

Use Case: We have a subtable with records, however, these are not sorted. We have logic to extract, sort and reinsert these in a sorted order, but this creates new nwIds which breaks referential integrity.

Ideally we would like to reinsert these with their original nwIds to keep any existing data happy.

Any thoughts?

2

I’m not sure this is possible, but I would like to understand more about the Referential Integrity setup that involves the Subtable records - can you elaborate on that?

1 Like
3

Ian is correct. The platform does not currently support this concept. Even if an nwId is provided to the insert the provided value will be discarded and a new nwId created.

4 Likes
4

Thanks for the quick reply.

We are storing a setting/code in a subtable(main) and referencing the subtable.nwId as a TL on the another table. We had a request to sort the setting/code - I tried the extract, fetch sorted and insert method but this breaks the references on the other table so we abandoned the idea. That’s the reason for the ask.