I know it. But I have my own big application that was developed for MS SQL. Now I need move it to Oracle. Qualification like $Name$="" very much.
How could we correct it? -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Misi Mladoniczky Sent: Thursday, June 19, 2008 11:05 AM To: [email protected] Subject: Re: Remedy create wrong SELECT !!! Hi! It has allways worked like that. Change your qualification to $Name$=" " instead of $Name$="". Best Regards - Misi, RRR AB, http://rrr.se > Hi, all > > > > I found interesting thing. For example, we have form (Form1) that > contain character field $Name$ and table. Table look at another form > (Form2) that contain only character field $Name$. Table qualification is > ( 'Name' = $Name$) OR ( $Name$ = "" ). > > > > Open Remedy User and turn on database log. Open Form1. Leave $Name$ > field empty and refresh table. See log: > > > > SELECT T710.C1,C536870913,T710.C1 FROM T710 WHERE ((T710.C536870913 = ' > ') OR (' ' = '')) ORDER BY 1 ASC > > > > ((T710.C536870913 = ' ') OR (' ' = '')) is ( 'Name' = $Name$) OR ( > $Name$ = "" ). Empty field $Name$ is ' ' (space) in SELECT expression. > Why Remedy replace NULL character fields with space in SELECT. > > MS SQL Server convert (' ' = '') to ('' = '') automatically but Oracle > doesn't. Refreshing table works on SQL Server but does not work on > Oracle. > > > > What can I do? > > > ________________________________________________________________________ _______ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > > -- > This message was scanned by ESVA and is believed to be clean. > > ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
