cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Learn all about the Community Ranking System, a fun gamification element of the PTC Community. X

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

seanccc
17-Peridot
17-Peridot
‎Jul 04, 2019 05:17 AM
‎Jul 04, 2019 05:17 AM

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

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

Labels:
0 Kudos
Notify Moderator
0 REPLIES 0
Top Tags