selective update not working

#1

we try to optimize for our queries and tried a selective update, but in explorer it just shows query execution error:

 

UPDATE ObjectNode o SET o.state = 5 where o.classIdentifier = '(MA)' and o.objectNameUpper = 'DMU200P2' and  o.state = 0 and o.type = 1 and o.parentNode.classIdentifier = '(NC)'
#2

This query includes an implicit JOIN (o.parentNode.classIdentifier), which is not allowed in UPDATE queries. See this stackoverflow thread for a more detailed explanation.

ObjectDB Support

Reply