Re: Way to 'escape' a keyword in a query?

>From: uunet!prem.lbl.gov!prem (xyz) >Subject: Way to 'escape' a keyword in a query? >Date: 26 Feb 1993 18:08:05 GMT >X-Informix-List-Id: <news.2720> >Does any of you know of a way in Informix ESQL v2.10 to 'escape' >a column name which happens to be a keyword? I have a column called >NAME in one of the tables, and need to update that column. How can >I turn of the special keyword meaning of NAME, so that I can refer to >it in my program? In ESQL v2.10, you cannot do it. In 4.00, you would have to prefix the column name with a table name or table alias. In 5.00 and above, you could use the name unescaped. I think 4.10 would behave as 5.00 does; if not, it behaves as 4.00 does. Why are you using such an old version of the software? Yours, Jonathan Leffler (johnl@obelix.informix.com) #include <disclaimer.h>