This is just a guess, try putting " " (literally type quote space quote) in
the EmptyValueFormula of the data object column (and change OnEmptyValue to
'Use Formula'.
And let us know what actually works.
-- Curt Springer, Team ND
At 12:08 PM 6/9/99 -0700, Larry Woods wrote:
>Mary (or anyone),
>
>What if you want to send a blank (not a null) to the database if the field
>is empty? Can you do this using an onEmptyValueFormula? What is the syntax?
>
>This question has been asked before, but my search of the forums found no
>answer....Thanks.
>
> --Larry
>
>[EMAIL PROTECTED]
>>Date: Tue, 08 Jun 1999 13:13:37 -0400
>>From: Mary Hill <[EMAIL PROTECTED]>
>>Subject: Re: [ND] Set Null Value to Update DataObject Parameters.
>>
>>In the properties window for a data object field, there is a key
>>"OnEmptyValue" , this is what tells NetDynamics what to do with
>>null fields. The default is to exclude them from the query. This is
>>because
>>you might not want to include all the fields in an update, and this allows
>>you to
>>exclude some fields. You can change the setting to 'Send Null' or you can
>>provide
>>a formula.
>>
>>"A.Velmurugan" wrote:
>>
>>> Hi,
>>> I am working in ND4 and i want to set Null value to a Update
>>> DataObject Parameter. The code that i used follows,
>>>
>>> CSpUpdate doUpdate = (CSpUpdate)
>>> CSpider.getDataObject("doMonthUpdate");
>>> doUpdate.setValue("Name",new CSpNull());
>>>
>>> But, the field 'Name' is excluded from the Update Query.
>>> Could any one help in this regard.
>>>
>>> Regards,
>>> A.Velmurugan.
>>>
>>> _________________________________________________________________________
>>>
>>> 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]
>>
>>--
>>--------------------------------------------------------
>>Mary Hill 2919 Taubman Library
>>[EMAIL PROTECTED] 1135 E. Catherine
>>University of Michigan Ann Arbor, MI
>>Med School Information Systems 48109-0726
>> 734-763-6752
>>
>>
>>_________________________________________________________________________
>>
>>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]
>>
>>
>_________________________________________________________________________
>
>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]
>
_________________________________________________________________________
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]
