Subject | Re: [IBO] Creating Stored Procedure with IB_Script, Problem with a reserved name field |
---|---|
Author | Helen Borrie |
Post date | 2006-11-14T10:58:19Z |
At 08:53 PM 14/11/2006, you wrote:
are using, the dialect of your database, the dialect you are using in
your client connection; and also what version of IBO.
Helen
>Hello,Tell us what versions of the client library and server executable you
>
>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?
are using, the dialect of your database, the dialect you are using in
your client connection; and also what version of IBO.
Helen