Are keys returned in the order of addition?

152 viewsdriver development primary key SLScripting
4
0 Comments

Hi everyone,
if we were to retrieve a table's primary keys via the getcolumn notify, are the returned keys in the order of how they were added into the table? Or is it completely random?

João Severino [SLC] [DevOps Catalyst] Answered question 25th September 2024

1 Answer

5
11.72K 0 Comments

Hi,

When retrieving primary keys you should not assume they come in any specific order.

Ordering is only done when displaying the data to the user.

The only guarantee is that if you retrieve multiple columns at the same time the returning data will have the same order between each retrieved column.

João Severino [SLC] [DevOps Catalyst] Answered question 25th September 2024