0 Replies Latest reply on Oct 8, 2002 11:51 AM by Louis

    How to set CHAR value for the condition clause

    Louis Newbie

      Hi, I am using the Hypersonic SQL database for the persistence storage. In one table, I have a CHAR type collumn which causing me a lot of trouble for ejb-ql statement. I tried the following sql statements, but they are failed when I try to deploy it.


      <ejb-ql><![CDATA[
      SELECT OBJECT(g) FROM NodeEJB g WHERE g.nodeType = 'N'
      ]]></ejb-ql>



      <ejb-ql><![CDATA[
      SELECT OBJECT(g) FROM NodeEJB g WHERE g.nodeType = N
      ]]></ejb-ql>


      where the collumn nodeType is the CHAR data type. I tried using the character braced by '' or {} or () or """" but they all failed.

      I want to know what is right format for setting the char data type value.