"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___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
