Subject | Creating Stored Procedure with IB_Script, Problem with a reserved name field |
---|---|
Author | Andrew |
Post date | 2006-11-14T09:53:28Z |
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?
Thanks
Andrew
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?
Thanks
Andrew