I am trying to run an execute command to update the tea commerce CustomOrderLineProperty table but the query that is run (although correct) does not update the table but running it manually in management studio works.
I am aware that there are dependancies within the db that stop any update in the data FOR THE CURRENT ORDER being implemented (I ran a Delete query and it deleted everything except the current order) but should the SuppressDependency enable me to overide the dependencies?
I want to be able to update a Key,Value row but the current restrictions stop me from implementing.
Tea Commerce - Updating Tables
I am trying to run an execute command to update the tea commerce CustomOrderLineProperty table but the query that is run (although correct) does not update the table but running it manually in management studio works.
I am aware that there are dependancies within the db that stop any update in the data FOR THE CURRENT ORDER being implemented (I ran a Delete query and it deleted everything except the current order) but should the SuppressDependency enable me to overide the dependencies?
I want to be able to update a Key,Value row but the current restrictions stop me from implementing.
Hi Stephen
Could you try and describe a bit more what you want to do - the use case. Just to figure out the best way to do it.
is working on a reply...