This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
I want to assign String.Empty into a non-nullable column in the database. It looks like mindscape translate String.Empty to a null and cause an error. Is there a setting to not translate String.Empty to null? Thanks |
|
|
We don't translate String.Empty to null. Are you on Oracle? If so, this is an Oracle issue -- that database treats the empty string as null. (It's outstandingly annoying!) Also, is the error definitely happening in the database, or is it a LightSpeed validation error? If so, you may have Validate Presence set to true, which will treat an empty string as a validation error. |
|
|
Thanks. Setting the Validate Presence to false does the trick. |
|