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