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)
 
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 )
-------------------------------------------------  
  

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

Reply via email to