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