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]
