Curt,
That worked. Thanks.
--Larry
>
>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]
>
>
_________________________________________________________________________
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]
