Hi Adam

At this stage I am getting previously written software up to a working
module. The software was written about 3 or 4 years ago and
unfortunately there is not enough funding in the project for me to
redo/port the TQuery over to other free components such as MDO or IBX.
I believe it would involve quite a bit of rework of the software.

At this stage, I think I will try to get the schema changed and get
the prototype working.

Thanks to all again,

Gaurav

On 2/18/06, Adam <s3057043@...> wrote:
> --- 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
>
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> 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