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"
