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"
