i have a nullable integer column in my database. let's say, table1.COL1. and suppose there's a relationship between table1.COL1 and table2.COL2.
i created a textbox field to edit table1.COL1. if i enter an integer and there is a counterpart in table2 everything is fine. the problem arises when i try to keep the textbox blank.
the generated query is something like:
update table1
set col1=''
where ...
and sqlserver is returning an error because it doesn't find the foreignkey '' in table2.
how can i tell codex that '' means null?
should i create a new plugin that combines a checkbox and a textbox? (if the checkbox is empty, then the value is discarded... hum... but how can i unset that value... it's not clear to me).
