Hi Helen,

Thanks for your reply,

The problem is now resolved.

I have been informed that the table I was having problems with is an
Old table that was created prior to "Type" being a reserved word.

Many thnaks

Andrew

--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@...> wrote:
>
> At 08:53 PM 14/11/2006, you wrote:
>
> >Hello,
> >
> >I am trying to create some stored porcedures for our database
tables
> >and I'm encountering a problem with a few tables.
> >
> >I have a table with a field called TYPE.
> >
> >I write the create procedure SQL into the IB Script component and
> >then Execute the script, I receive the following error.
> >
> >Token Unknown Line 132 Char 9 TYPE
> >
> >as Type is a reserved word I decided to quote the fieldname as
below:
> >
> >"Type"
> >
> >now when I run the script I receive the same error.
> >
> >Token Unknown Line 132 Char 9 "TYPE"
> >
> >What do I need to do to resolve this problem?
>
> Tell us what versions of the client library and server executable
you
> are using, the dialect of your database, the dialect you are using
in
> your client connection; and also what version of IBO.
>
> Helen
>