Thank you.



________________________________
From: Ben Chernys <ben.cher...@softwaretoolhouse.com>
To: arslist@ARSLIST.ORG
Sent: Tuesday, February 10, 2009 11:09:03 AM
Subject: Re: API setting field to null vs NULL

** 
"null" and "NULL" are two non-null strings.  
 
ARS uses the keyword $NULL$ to indicate a null value.  When an API program sets 
a field to NULL the "dataType" field in the ARValueStruct is set to 
AR_DATA_TYPE_NULL (0) with the rest of the struct ignored (but "should" be 
zero).  
 
See ar.h
 
Cheers
Ben
 
www.softwaretoolhouse.com


________________________________
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Bala Patel
Sent: February 10, 2009 4:59 PM
To: arslist@ARSLIST.ORG
Subject: API setting field to null vs NULL

** 
All,

ARS 6.3
SQL Server 2000

We have an API that was created by another vendor. I noticed that the NULL 
values that are being set into fields are in lower case. The User Tool creates 
the NULL values in uppercase.  Does it matter if a value of NULL is upper or 
lower case.  I am looking at the column values via Query Analyzer.

External API sets field to: null
User Tool ticket creation sets field to a value of : NULL

Thanks,

Bala Patel
Remedy Administrator


__Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ 
__Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___





_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"

Reply via email to