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

ThingWorx Navigate is now Windchill Navigate Learn More

Translate the entire conversation 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