cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Visit the PTCooler (the community lounge) to get to know your fellow community members and check out some of Dale's Friday Humor posts! X

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

seanccc
17-Peridot

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

0 REPLIES 0
Announcements


Top Tags