🚀 go-pugleaf

> >>> You need to double quote the reserved words.  Remember this makes it
> > case
> >>> sensitive so make sure the column is all caps.
> >>
> >> The two columns I am dealing with are PERCENT and TYPE.  In IBConsole,
> > using
> >> Interactive SQL, I put in this statement:
> >>
> >> ALTER TABLE footage ALTER "PERCENT" TO pct;
> >>
> >> I get back:
> >>
> >> SQL error code = -104
> >> Token unknown - line 1, char 26
> >> "PERCENT"
> >>
> >> There is definitely a column named PERCENT.
> >>
> >> Any thoughts?
> >
> > What is the connection dialect?
> >
> > I think you need to use dialect 3 to use delimited identifiers.
>
>
> Thanks. I did it manually through IBConsole and it worked. How would I do
> this programmatically? Basically I want to be able to restore the backup
and
> run a script to change all the of the columns and such. I can do "SET SQL
> DIALECT" but that is only for the client. Is there an ALTER command or
> something to change the dialect? I've looked through the help and can't
seem
> to find it.  I would be doing this through IBExpress components in a
> Delphi2007 app.

You can set the database dialect by using the Services API (components).

Do note, however, that numeric columns based on NUMERIC or DECIMAL
won't change the underlying storage types (which can be SMALLINT to DOUBLE)
to the new int64.


-- 
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