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
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