I believe the databases are made in Interbase (perhaps an older
version). How do I find out what version ? I presume that the
databases were working with the code for this application before...but
I am not sure if there is some other incompatibility.

Gaurav

On 2/17/06, Paul Mercea <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
>
>
>
>
>
>
>


--



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