Data Manager SQL node - Error while Update

[sappleg]

Hi Guys,

I am currently working with Data Manager and inserting an SQL node to the build. I have incorporated a very simple update statement in this sql node. However, when I do this in sql helper, it is giving me following error:

UDA-SQL-0123: Insert/Update/Delete requests are not permitted in real only transactions.

At the same time, when I issue this update statement outside of Data manager against the database, it works.

Could someone please advise?
Thanks in advance.
Sappleg

 

[Kaiaualad]

You will be able to run it in Batch - just not from the GUI.