--- In firebird-support@yahoogroups.com, Gaurav Sood <sood.gaurav@...>
wrote:

>
> 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
>

Gaurav,

The immediate issue here is the reserved word Type. The more important
problem though is that it is a really bad idea to use the BDE to
connect to Firebird. It is unstable, slow, a pain to install and
unreliable. There are lots of different connection libraries that
provide equivalent classes to TQuery, and I can not think of a worse
component to use.

Adam