But if you look at a null row in sql tools it will typically show value 'null' in the fields...but when you click into the field it shows that it's actually blank...
_____ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Bala Patel Sent: Tuesday, February 10, 2009 9:32 AM To: arslist@ARSLIST.ORG Subject: Re: API setting field to null vs NULL ** 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 <http://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___ __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"