According to Helen book short article "how to mess up with your database
" , there should be added out this one :
a) Give to your variables, tables, domains, collumns SP, triggers or
any of metadata objects same names where possible.
b) Give to your variables, tables, collumns SP, triggers or any of
metadata objects names which are close or identical to any of the
reserved words, like "type,subtype,year, all, first,user,sum,time etc etc ".
:)
Adomas
Paul Mercea wrote:

>Hi
>What version of FireBird are u using?
>In Firebird 2 TYPE word are no longer reserved, I presume in fb 1.5.x is
>reserved by FB.
>
>Regards
>Paul
>
>-----Original Message-----
>From: firebird-support@yahoogroups.com
>[mailto:firebird-support@yahoogroups.com] On Behalf Of Gaurav Sood
>Sent: Friday, February 17, 2006 8:09 AM
>To: firebird-support@yahoogroups.com
>Subject: [firebird-support] Simpe query gives unidentified token error
>
>Hi All,
>
>I have a simple table Sampletypes (Type, Description). If I do a
>Select * , I get the table eg.
>Type Description
>===== ===========
>A Articulation
>C Conversation
>
>
>There is a second table PersonTypes (Type, Description) as follows:
>Type Description
>===== ===========
>Client Person whose speech is analysed
>Guardian Person who is legally responsible for a client
>
>When I do a simple query
>'Select Description
>from Sampletypes
>where type=:Type'
>
>I get the following error:
>
>General Sql Error: Token Unknown -line 3, char 7 TYPE.
>
>Is there some type of conflict in the two 'Type' columns that is
>preventing my TQuery function or other queries from working ?
>
>Also, when passing a variable with the colon : VariableName, how
>
>
>Cheers,
>Gaurav
>
>
>
>
>--
>
>
>
>Analyst
>B. Engineering, B. IT
>A.N.U (2004)
>
>M: +61 401 409 620
>H: +61 3 9376 8580
>
>
>"In life, always do right. This will gratify some people and astonish the
>rest."
>
> - Mark Twain
>
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Visit 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
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Visit 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
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>

--

Pagarbiai / Best Regards,
Adomas Urbanavicius
+37068543336