🚀 go-pugleaf

On 2/29/08 4:14 AM, in article 47c7cc94@newsgroups.borland.com, "Martijn
Tonies" <m.tonies@upscene.removethis.com> wrote:

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