Thanks Fred It should behave equally in the native application in Remedy and the external interface. As it can be seen before I start "*My Approch*" the system was behaving differently for the native and external application. Not able to get here ?? :(
-- Thanks and Regards, Ganga Prasad Pattnaik, ( Remedy Skilled Professional ) ------------------------------------------------- On Fri, Apr 11, 2008 at 6:40 PM, Grooms, Frederick W < [EMAIL PROTECTED]> wrote: > ** Null is defined by the ISO SQL standard as different from both an empty > string or the numerical value 0. Null indicates the absence of any value, > the empty string and numerical zero both represent actual values. > > From: > http://en.wikipedia.org/wiki/Null_(SQL<http://en.wikipedia.org/wiki/Null_%28SQL> > ) > > Fred > > ------------------------------ > *From:* Action Request System discussion list(ARSList) [mailto: > [EMAIL PROTECTED] *On Behalf Of *Ganga Prasad > *Sent:* Friday, April 11, 2008 7:40 AM > *To:* [email protected] > *Subject:* Difference between NULL and "" > > Hi all > > Is there any difference between NULL and "" in a character field ?? > *My Scenario* > I have a character field. The value to the character field is supposed to > come from a already existing backend from. > *My Requirement.* > On saving I should not be able to save any value in the character field > other than whatever record is present in the BACKEND Form > *My Solution* > I wrote a filter (RUNIF : character field != NULL) which will go for a > SQL. The SQL will find out the present value in the ticket with the BACKEND > record. Once it is finding, it will make a flag field with count of records > found (Usually 1). If no backend records found then it will make the flag 0( > zero matching records) > The very next filter will check for the value in the Flag field; If it is > 0 then give a error message > *My problem > *It is working as expected as long as I am opening my Remedy client and > save the ticket. > But when I am trying to create a ticket in my application through another > application by XML without passing the value to the character field it is > throwing an error to the originating system.One strange thing is that if in > the xml if i am removing the <characterfield> completly; it is working fine. > *My Approach* > I approached with hit and trial method that before going for SQL I set the > character field NULL if it is "". Now it is working fine. > *My Doubt* > Is this the way remedy should behave ?? is there any diff between NULL and > "" ?? > *My Setup* > ARS V 7.0.01 P003 > No ITSM > Completely Customized appl. > > -- > Thanks and Regards, > Ganga Prasad Pattnaik, > ( Remedy Skilled Professional ) > ------------------------------------------------- > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

