Subject RE: [firebird-support] Simpe query gives unidentified token error
Author Si Carter
> -----Original Message-----
> General Sql Error: Token Unknown -line 3, char 7 TYPE.

TYPE is a reserved word, if you can't change your schema then reference the
column using dbl quotes "TYPE", this method is case sensitive and is, AFAIK,
only available in dialect 3, could be wrong though :-)

> Is there some type of conflict in the two 'Type' columns that
> is preventing my TQuery function or other queries from working ?

Yes, see above.

> Also, when passing a variable with the colon : VariableName, how

Try something like:

'Select Description
from Sampletypes
where "type"=:Type'

But to be honest, your probable better off changing your schema to a more
descriptive name, i.e. PersonType.

Hih

Si Carter
http://www.fbtalk.net/ - Web Based Firebird Forum
http://sourceforge.net/projects/fbutils - FBUtils
http://sourceforge.net/projects/dnfBB - Web based, Firebird Powered Forum