I am trying to update a SQL field to NULL, however it is being set as 0

jQuery.dmxDatabaseAction(
{"id": "ExecUndeleteP", "url": "dmxDatabaseActions/UndeletePRecord.asp", "data": {"PersRec_Deleted": "(null)", "PersRec_RecordId": "{{$FORM.DeletedRec}}"}, "success": "dmxDataBindingsAction('refresh','PRecords',{});"}
);

I have tried NULL, "", "NULL" and still cannot update the integer column to a NULL value.
Any help would be appreciated

Hello,
What is your DB field type? also - is your database column set to use null for default value?

Hi Teodor,
Its SQL 2008 tinyint
Its not a primary key and and yes allow nulls is true, defaults to NULL and length is 1

My dmxConnection reports the field as {"type": 17, "nullable": 1},

So you cannot insert the word "null" and expect this to be the same as null value in the database
I will check if this is really possible with the database updater and will let you know.

This reply was removed on 10/30/2015 8:35:42 AM.
See the changelog

Hi Teodor,
When I do not assign a value in the action executor it updates the value to 0