Subject Re: [IBO] Creating Stored Procedure with IB_Script, Problem with a reserved name field
Author Helen Borrie
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