You probably need to go the element in your data object that is bound to the
textbox and change the "OnEmptyValue" property from "Exclude" to "Send
Null". This will cause a null value to be sent in the generated update SQL
statement. "Exclude" leaves the field out of the SQL Update.
Jim Ierardi
OLC Software, Inc.
<[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hi,
> I have a text box(bound) and an update button(built in). If I change the
value in the text box and click update, the database gets updated
correctely. However, if I make the textbox empty and click update, nothing
happens. The corresponding datafield instead of being set to null remains
unchanged.
> Is there a way to get around this problem, other than using the
executeUpdate statement.
>
> Any help is highly appreciated.
>
> Thanks
> -Hetal
>
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
