Re: Case insensitive queries

Here is some actual working code. I'm not quite sure why it's written this way. It was a loong time ago (you mean people still use forms??!!).

      DEFINE TRIGGER

         NAME = PRE-QUERY
         TRIGGER_TYPE = V3
         TEXT = <<<
         if  :point.point_desc is not NULL then
             :point.point_desc
             := '#=point_desc and upper(point_desc) like '''||
             upper(:point.point_desc) ||'''';
         end if;
         if  :point.status is not NULL then
             :point.status
             := '#=status and upper(status) like '''||
             upper(:point.status) ||'''';
         end if;
         if  :point.latest_text_value is not NULL then
             :point.latest_text_value
             := '#=latest_text_value and upper(latest_text_value) like '''||
             upper(:point.latest_text_value) ||'''';
         end if;


         >>>


      ENDDEFINE TRIGGER