Skip to main content
17-Peridot
July 4, 2019
Question

Does thingworx generate SELECT .... FOR UPDATE command ?

  • July 4, 2019
  • 0 replies
  • 498 views

Hi , 

To update an existing entry, I'll call the two services: 

1. GetDataTableEntryByKey

2. UpdateDataTableEntry

 

There may be several users to update the same entry with the different field value at the same time , so to avoid the update last , I think SELECT ... FOR UPDATE should be used.   Does thingworx generate such SQL ?  If not ,how should I make sure the data consistent ? 

 

Regards,

Sean