Re: Select text data type statement in Informix Web Datablade cannot work!!

In article <34017DAF.37E7@silicon.net.my>, Kok Fock Seng <fskok@silicon.net.my> writes >Hi out there, > > I am using web datablade to access an Informix database >from the web. The situation is like this : > >I have a Select statement that select a column that the data >type is text and it just returned a error. I am very new to >Informix and SQL. The same thing happened when I implement a >where condition which related to a text column. How do I proceed >to solve this??? > >Well, in the first place, is it possible for me to select from >a text data field??? I'm not sure about this, but I find lvarchar columns are often more useful than text columns, though you still can't index them (directly). -- Chad Hanna Chad Hanna and Associates connect RDBMS to WWW Project Co-ordinator Berkshire Family History Society