It is not listed as such in FirebirdRefGuide.pdf (page 287-288) and my
query of the table STATE works fine in IB_SQL using the server. The
problem seems to be fixed now (see earlier post). Other DBMS might have
this problem?

Walter

At 08:01 PM 7/13/2005, you wrote:

>I believe STATE is a reserved word. We had to name our table states for
>that reason.
>
>Adam
>
>
>
>
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Visit <http://firebird.sourceforge.net>http://firebird.sourceforge.net and
>click the Resources item
>on the main (top) menu. Try Knowledgebase and FAQ links !
>
>Also search the knowledgebases at
><http://www.ibphoenix.com>http://www.ibphoenix.com
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>
><?---- LSpots keywords ?>
>
>SPONSORED LINKS
>Technical support Computer security Computer technical support
>Computer training Free computer technical support
>
>
>----------
>YAHOO! GROUPS LINKS
>
> * Visit your group
> "<http://groups.yahoo.com/group/firebird-support>firebird-support" on the web.
> *
> * To unsubscribe from this group, send an email to:
> *
> <mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>firebird-support-unsubscribe@yahoogroups.com
>
> *
> * Your use of Yahoo! Groups is subject to the
> <http://docs.yahoo.com/info/terms/>Yahoo! Terms of Service.
>
>
>----------

/*
C. Walter Ogston
ogstoncw@...
*/