[Openroad-users] QueryObject again - different problem

[Karl & Betty Schendel]

At 3:13 PM -0400 6/28/07, Collins, William - ES/EW wrote:
>I have a QueryObject that works fine until it tries to query a table containing a column named 'direct'. I get error E_US09C5 Syntax error on 'direct'Š


I can't pretend to know what OpenROAD is doing, but if you're
running against an Ingres DBMS server, I don't think the
error is coming from there.  At least, not because of DIRECT
being a keyword.

I had thought that OR might be issuing a cursor query
and getting into trouble with the FOR [DIRECT | DEFERRED] UPDATE
clause.  But, as it happens, Ingres does NOT see DIRECT as a
keyword;  the scanner recognizes FOR DIRECT as a one double-word
keyword, and FOR UPDATE as another, but DIRECT by itself is not
a keyword.

As for a workaround, try creating a view with that one
column renamed.

Karl