How to get last inserted RowID when %Save() function is used?

Question

Question

Vivek Nayak · Aug 27, 2019

#Database Transaction Processing #Frontend #Caché #InterSystems IRIS

I need RowId of inserted record.

I have used below logic to get max row id,

but it will not give desired result when multiple people enter record in the table at the same time.

Discussion (7)1

Log in or sign up to continue

Evgeny Shvarov · Aug 27, 2019

Hi Vivek!

Instead of &sql ...

you can do:

write objExternalUser.%Id()

0 0

score 0 · Answer 1 · 2019-08-27T10:09:40-04:00

Michel Bruyère · Aug 27, 2019

What purpose for the max RowId ?

0 0

score 0 · Answer 2 · 2019-08-27T10:45:39-04:00

So, If I am using objExternalUser.%Id() then which Id I ll get

1) Id of record inserted by my objExternalUser.%Save() function?

2) Id of latest inserted record?

score 0 · Answer 3 · 2019-08-27T10:50:00-04:00

Sorry Vivek. My code provides you the Id of objExternalUser you save (possible create) above. It's 1).

It's not the latest inserted record. I thought you need:

I need RowId of inserted record.

Out of curiosity: why do you need the latest record?

score 0 · Answer 4 · 2019-08-28T03:50:34-04:00

Thanks Evgency,

I got my answer, actually I need the Id of record inserted by my objExternalUser.%Save() function and that I got by your answer( objExternalUser.%Id() )

score 0 · Answer 5 · 2019-08-28T03:51:53-04:00

Evgeny Shvarov · Aug 28, 2019

Great! Happy to hear that

0 0

score 2 · Answer 6 · 2019-08-28T02:01:28-04:00

When you create a class that the IDs are maintained by the system (standard class without modifying the storage, then there is a save mechanism to give a new ID to every new object that is being saved to the database.

Of course that when multiple users are saving new data simultaneously , a specific process ID after a %Save() might not be the last one in the table.

How to get last inserted RowID when %Save() function is used?

Social networks

InterSystems resources