Subject | RE: [firebird-support] Simpe query gives unidentified token error |
---|---|
Author | Si Carter |
Post date | 2006-02-17T09:59:07Z |
> -----Original Message-----TYPE is a reserved word, if you can't change your schema then reference the
> General Sql Error: Token Unknown -line 3, char 7 TYPE.
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 thatYes, see above.
> is preventing my TQuery function or other queries from working ?
> Also, when passing a variable with the colon : VariableName, howTry 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