Subject Re: [IBO] "unsupported column type" on CREATE TRIGGER
Author Martijn Tonies
> >I'm first doing a Prepare. Should IBO try to create params even though
> >it's a DDL statement?
>
> In case Jason is offline again, I'll answer this Martijn. The purpose of
the Paramcheck flag is exactly so that a variable reference in a PSQL
declaration will NOT be treated as a parameter when the flag is false.
Always set it false for a DDL statement or script.
>

That's what I thought. The reason I was just checking is that the
parsing has been updated, I figured it might "know" it's DDL and
work fine by not parsing for parameters.

Thanks for the confirmation though.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com